Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question