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