Re: copy tables
| От | Dau Sy Manh |
|---|---|
| Тема | Re: copy tables |
| Дата | |
| Msg-id | CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com обсуждение |
| Ответ на | copy tables ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>) |
| Список | 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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Shavonne Marietta Wijesinghe
Sent: vendredi 14 octobre 2005 13:55
To: pgsql-sql@postgresql.org
Subject: [SQL] copy tablesHello
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 по дате отправления: