From: Dau Sy Manh <dsmanh@ifisolution.com>
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: pgsql-sql@postgresql.org
Subject: Re: copy tables
Date: Sat, 15 Oct 2005 09:38:58 +0700
Message-ID: <CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com> (raw)
In-Reply-To: <001601c5d08c$26339240$1102a8c0@dream>
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 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dsmanh@ifisolution.com, shavonne.marietta@studioform.it
Subject: Re: copy tables
In-Reply-To: <CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox