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'm not sure how to do this?

Answer 1

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

Answer 2

You should be able to use the database link like this:

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

Answer 3

If you have postgres contrib installed, you need to enter it once: psql:

CREATE EXTENSION dblink;