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 !
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.