| From: | "Dau Sy Manh" <dsmanh(at)ifisolution(dot)com> |
|---|---|
| To: | "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: copy tables |
| Date: | 2005-10-15 02:38:58 |
| Message-ID: | CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Shavonne Marietta
Wijesinghe
Sent: vendredi 14 octobre 2005 13:55
To: pgsql-sql(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | paperinik 100 | 2005-10-15 08:49:15 | problems with array |
| Previous Message | Tom Lane | 2005-10-14 18:28:24 | Re: FULL OUTER JOIN Question |