@
@
@mgyk2014-01-14 12:44:12
linux
@mgyk, 2014-01-14 12:44:12

PostgreSQL: how to skip tables from dump file?

Tell me how you can filter data from a PostgreSQL binary dump.
Now I'm downloading a full dump and using pg_restrore -L db.list I create only the tables I need, but I want to somehow convert the main dump so that I can download only the necessary data.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
pkorobeinikov, 2014-01-14
@pkorobeinikov

Perhaps the -t (--table) switches for pg_restore will help you.
The -t switch can be used multiple times.
The -t switch is also available for pg_dump.
However, be careful, you may run into problems when you try to dump/restore tables related to other tables.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question