Re: how to copy table to another database?

On Fri, 18 Jul 2003, Yudie wrote:

> Hi,
> Anyone know how the procedure or commands to copy table to another database.
> or querying from another database if possible?

If you want to copy a table from one db to another, you can use this:

pg_dump dbname -t tablename |psql dbname -e

If you want cross database queries, look in the /contrib/dblink dir in the 
tarball of postgresql