Re: [SQL] copy tables

[Dau Sy Manh]

In DATA1 you run SQL Query: copy A to 'PATH\tempA.txt'   Then in DATA2 you run SQL Query: copy A from 'PATH\tempA.txt'   good luck ! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Shavonne Marietta Wijesinghe Sent: vendredi 14 octobre 2005 13:55 To: pgsql-sql@postgresql.org Subject: [SQL] copy tables  Hello I have 2 postgreSQL databases called "DATA1" and "DATA2" with several tables inside them (table A, B, C). I modify the details in table "A" in database "DATA1" How can I copy table "A" from database "DATA1" and paste it in database "DATA2" using the same table name ?? Thank you.