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?

janfoeh · Accepted Answer · 2015-02-13 14:03:56Z

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, 2015 at 14:03

janfoeh

10.3k3 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BillRobertson42 Over a year ago

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.

Community · Accepted Answer · 2017-05-23 11:53:56Z

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, 2017 at 11:53

CommunityBot

11 silver badge

answered Mar 2, 2017 at 20:20

Anvesh

7,8073 gold badges48 silver badges45 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related