KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a database with hundreds of tables, what I need to do is export specified tables and insert statements for the data to one sql file. The only statement I know can achieve this is pg_dump -D -a -t zones_seq interway > /tmp/zones_seq.sql Should I run this statement for each and every table or is there a way to run a similar statement to export all selected tables into one big sql big. The pg_dump above does not export the table schema only inserts, I need both Any help will be appreciated.
Tags (comma-separated)
Save Edits
Cancel