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

Question

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

pugmarx · Accepted Answer · 2011-05-16 10:40:44Z

3

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

answered May 16, 2011 at 10:40

pugmarx

7,4534 gold badges32 silver badges40 bronze badges

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

Comments

StevieG · Accepted Answer · 2011-05-16 10:35:43Z

0

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

answered May 16, 2011 at 10:35

StevieG

8,7391 gold badge26 silver badges33 bronze badges

Could you add a bit to that answer? I get "function dblink... does not exist".. Any idea's how to get around that?

Aashi Deacon · Accepted Answer · 2013-09-10 19:00:38Z

0

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

CREATE EXTENSION dblink;

answered Sep 10, 2013 at 19:00

Aashi Deacon

1