CODEWITHSUNDEEP
databasepostgresql
sda
sda

Reputation: 45

how to copy data from one database to another database in postgresql?

I am trying to copy tables from one postgresql8.4 to another postgresql8.4 and I am not sure how do I do that?

Upvotes: 4

Views: 11357

Answers (3)

Aashi Deacon
Aashi Deacon

Reputation: 1

if you have postgres contrib installed you need to type this once is psql:

CREATE EXTENSION dblink;

Upvotes: 0

pugmarx
pugmarx

Reputation: 7423

Can't you just take pg_dump from one and import in another? Seems quite trivial.
Take a look at this: http://www.postgresql.org/docs/8.4/static/backup-dump.html

Upvotes: 3

StevieG
StevieG

Reputation: 8709

You should be able to so it using a database link:

http://www.postgresql.org/docs/8.4/static/contrib-dblink.html

Upvotes: 0

Related Questions