Thread: how to copy table to another database?

Yudie wrote:

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

Something like this, perhaps?

psql -d first_database -c '\copy mytable to stdout'  | psql -d 
second_database -c '\copy mytable from stdin'

I hope, it helps...

Dima

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