Postgres Pro
Downloads
Home   >   mailing lists

Re: copy tables - Mailing list pgsql-sql

From Dau Sy Manh
Subject Re: copy tables
Date
Msg-id [email protected]
Whole thread Raw
In response to copy tables  ("Shavonne Marietta Wijesinghe" <[email protected]>)
List pgsql-sql
Tree view
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: [email protected]
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.

 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: FULL OUTER JOIN Question
Next
From: Mike Plemmons
Date:
Subject: Question about functions