Postgresql – How to copy a table from one SQL database to another

databasepostgresqlsql

I have a database (it's Postgres, if that matters) and I would like to take two of its tables, export them, and then import them into another database. How do I do that?

Edited to add Google bait: dump load

Best Answer

Use pg_dump with the -t option (which you can specify multiple times):

pg_dump -t foo -t foo1 dbname1 > dump.sql

Restore in the new database:

psql -U username dbname2 < dump.sql
Related Topic