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_
![Creating a database dump for specific tables and entries Postgres](https://cdn-ak-scissors.b.st-hatena.com/image/square/98d6f053a97a87156775f60757c60865d0f2c47d/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fstackoverflow%2FImg%2Fapple-touch-icon%402.png%3Fv%3D73d79a89bded)