PostgreSQL - copy data from one table, database, server to another table, another database, server

Question

What would be the best way to copy data from one table, one database, one server to the table in another database, another server in PostgreSQL?

score 12 · Accepted Answer · answered Feb 13 '15 at 14:03

12

pg_dump allows the dumping of only select tables:

pg_dump -Fc -f output.dump -t tablename databasename

(dump 'tablename' from database 'databasename' into file 'output.dump' in pg_dumps binary custom format)

You can restore that dump on your other server with pg_restore:

pg_restore -d databasename output.dump

If the table itself already exists in your target database, you can import only the rows by adding the --data-only flag.

answered Feb 13 '15 at 14:03

janfoeh

2

If you're using pgadmin3, you can run pg_dump/pg_restore by right clicking on a database or table and choosing the backup/restore menu items. It's OK for simple one off tasks. – BillRobertson42 Feb 13 '15 at 15:08

score 0 · Answer 2 · edited May 23 '17 at 11:53

0

I shared a shell to copy table from one server to another PostgreSQL server. Please refer this another stack question. Copying PostgreSQL database to another server

edited May 23 '17 at 11:53

Community

answered Mar 02 '17 at 20:20

Anvesh

2 Answers2