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


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to