Backuping a single table from a database

pg_dump -U username -d database1 -t table_name > /home/backups/table_name.sql

Restoring the table into another database

psql -U username -d database2 < /home/backups/table_name.sql

Advertisements