How to restore several tables in one schema from a whole PostgreSQL database dump?

Question

PostgreSQL

Good evening.
There is a base dump, which I always filled in entirely through pg_restore. Like this:

pg_restore -c -v -F c -j 8 -d base ./dump-base-20170206.tar &> restore_20170206.log

Now I need to fill in not a whole dump into the database, but only two tables from one schema. That is, take schema1.table1 and schema1.table2 from the backup and upload only them. How to do it?

Answer 1

You can restore favorite tables with the -t switches.
https://www.postgresql.org/docs/current/static/app...