postgresql 如何在postgresql中将数据从一个数据库复制到另一个数据库？

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

提问by sda

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

我正在尝试将表从一个 postgresql8.4 复制到另一个 postgresql8.4，但我不知道该怎么做？

采纳答案by pugmarx

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

你不能只pg_dump从一个中取出并导入另一个吗？看起来很琐碎。
看看这个：http: //www.postgresql.org/docs/8.4/static/backup-dump.html

回答by Aashi Deacon

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

如果你安装了 postgres contrib，你需要输入一次 psql：

CREATE EXTENSION dblink;

创建扩展数据库链接；

回答by StevieG

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

您应该能够使用数据库链接来实现它：

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

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