X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 088BBD8637 for ; Fri, 14 Oct 2005 23:40:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90813-10 for ; Sat, 15 Oct 2005 02:40:07 +0000 (GMT) Received: from mail02.powweb.com (mail02.powweb.com [66.152.97.35]) by svr1.postgresql.org (Postfix) with ESMTP id D229FD9807 for ; Fri, 14 Oct 2005 23:40:09 -0300 (ADT) Received: from dsmanh (unknown [222.252.42.24]) by mail02.powweb.com (Postfix) with ESMTP id E3ABA6CC47; Fri, 14 Oct 2005 19:40:10 -0700 (PDT) From: "Dau Sy Manh" To: "Shavonne Marietta Wijesinghe" , Subject: Re: copy tables Date: Sat, 15 Oct 2005 09:38:58 +0700 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C5D16C.448076B0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <001601c5d08c$26339240$1102a8c0@dream> Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 required=5 tests=[HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/175 X-Sequence-Number: 23028 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C5D16C.448076B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_0010_01C5D16C.448076B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
In=20 DATA1 you run SQL Query:
copy A=20 to 'PATH\tempA.txt'
 
Then=20 in DATA2 you run SQL Query:
copy A=20 from 'PATH\tempA.txt'
 
good=20 luck !
-----Original Message-----
From:=20 pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org]On=20 Behalf Of Shavonne Marietta Wijesinghe
Sent: vendredi 14 = octobre=20 2005 13:55
To: pgsql-sql@postgresql.org
Subject: = [SQL]=20 copy tables

 Hello

I have = 2=20 postgreSQL databases called "DATA1" and "DATA2" with several tables = inside=20 them (table A, B, C).

I modify the details in table "A" in = database=20 "DATA1"

How can I copy table "A" from database "DATA1" and = paste it in=20 database "DATA2" using the same table name ??

Thank you. =

 

------=_NextPart_000_0010_01C5D16C.448076B0--