From shavonne.marietta@studioform.it Fri Oct  14 06:55:12 2005
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 2553CD8379
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 03:55:12 -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 69280-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 06:54:40 +0000 (GMT)
Received: from smtpout05.attiva.biz (smtpout05.attiva.biz [85.37.16.3])
	by svr1.postgresql.org (Postfix) with ESMTP id E85BFD8045
	for <pgsql-sql@postgresql.org>; Fri, 14 Oct 2005 03:54:40 -0300 (ADT)
Received: from FBCMFE02B13.fbc.local ([192.168.30.90]) by smtpout05.attiva.biz
	with Microsoft SMTPSVC(6.0.3790.211);
	Fri, 14 Oct 2005 08:55:29 +0200
Received: from dream ([81.74.60.30]) by FBCMFE02B13.fbc.local with Microsoft
	SMTPSVC(6.0.3790.211); Fri, 14 Oct 2005 08:55:28 +0200
Message-ID: <001601c5d08c$26339240$1102a8c0@dream>
Reply-To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: <pgsql-sql@postgresql.org>
Subject: copy tables
Date: Fri, 14 Oct 2005 08:54:39 +0200
Organization: Studio FORM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0013_01C5D09C.E8FB3520"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-OriginalArrivalTime: 14 Oct 2005 06:55:28.0729 (UTC)
	FILETIME=[42F52C90:01C5D08C]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.446 required=5 tests=[AWL=0.418, HTML_60_70=0.027,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/151
X-Sequence-Number: 23004

This is a multi-part message in MIME format.

------=_NextPart_000_0013_01C5D09C.E8FB3520
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

 Hello

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

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

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

Thank you.=20


------=_NextPart_000_0013_01C5D09C.E8FB3520
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><!--StartFragment --><FONT face=3DArial>&nbsp;Hello<BR><BR>I have 2 =

postgreSQL databases called "DATA1" and "DATA2" with several tables =
inside them=20
(table A, B, C). <BR><BR>I modify the details in table "A" in database =
"DATA1"=20
<BR><BR>How can I copy table "A" from database "DATA1" and paste it in =
database=20
"DATA2" using the same table name ??<BR><BR>Thank you.</FONT> </DIV>
<DIV>
<P><FONT face=3D"Verdana, Arial, Helvetica, sans-serif" color=3D#ff66cc=20
size=3D2></FONT>&nbsp;</P></DIV></BODY></HTML>

------=_NextPart_000_0013_01C5D09C.E8FB3520--




From andreas.kretschmer@schollglas.com Fri Oct  14 07:25:54 2005
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 86EEDD79CC
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 04:25:54 -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 77277-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Oct 2005 07:25:51 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.171])
	by svr1.postgresql.org (Postfix) with ESMTP id 58038D77F4
	for <pgsql-sql@postgresql.org>; Fri, 14 Oct 2005 04:25:52 -0300 (ADT)
Received: from [194.25.154.138] (helo=webserv.wug.de)
	by mrelayeu.kundenserver.de with ESMTP (Nemesis),
	id 0MKxQS-1EQJwl0qgc-0000yP; Fri, 14 Oct 2005 09:25:43 +0200
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1EQJwl-0003iK-00
	for pgsql-sql@postgresql.org; Fri, 14 Oct 2005 09:25:43 +0200
Date: Fri, 14 Oct 2005 09:25:43 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: copy tables
Message-ID: <20051014072543.GG10299@webserv.wug-glas.de>
Mail-Followup-To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-sql@postgresql.org
References: <001601c5d08c$26339240$1102a8c0@dream>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <001601c5d08c$26339240$1102a8c0@dream>
X-DEST: 208
X-MSMail-Priority: High
X-Message-Flag: Really, I'm not out to destroy Microsoft. That will just be a
	completely unintentional side effect. (Linus Torvalds)
X-OS: Linux - weil ich es mir Wert bin!
X-Info: registrierter Linux-User 97922 http://counter.li.org
User-Agent: mutt-ng 1.5.9i (Linux)
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:51ea9561fc3f6d9539a2acd743e4748c
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.267 required=5 tests=[MISSING_MIMEOLE=0,
	X_MSMAIL_PRIORITY_HIGH=0.267]
X-Spam-Level: 
X-Archive-Number: 200510/153
X-Sequence-Number: 23006

am  14.10.2005, um  8:54:39 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
>  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 ??

Backup the table A from DATA1 and restore it into DATA2.

(pg_dump with -t dumps only the specified table)


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 



From dsmanh@ifisolution.com Sat Oct  15 02:40:14 2005
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <dsmanh@ifisolution.com>
To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>,
	<pgsql-sql@postgresql.org>
Subject: Re: copy tables
Date: Sat, 15 Oct 2005 09:38:58 +0700
Message-ID: <CNEEKEDNGLPHCKEBMDPFCEPCCAAA.dsmanh@ifisolution.com>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D552403402-15102005>In=20
DATA1 you run SQL Query:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D552403402-15102005>copy A=20
to 'PATH\tempA.txt'</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D552403402-15102005></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D552403402-15102005>Then=20
in DATA2 you run SQL Query:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D552403402-15102005>copy A=20
from 'PATH\tempA.txt'</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D552403402-15102005></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D552403402-15102005>good=20
luck !</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20
  pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org]<B>On=20
  Behalf Of </B>Shavonne Marietta Wijesinghe<BR><B>Sent:</B> vendredi 14 =
octobre=20
  2005 13:55<BR><B>To:</B> pgsql-sql@postgresql.org<BR><B>Subject:</B> =
[SQL]=20
  copy tables<BR><BR></FONT></DIV>
  <DIV><!--StartFragment --><FONT face=3DArial>&nbsp;Hello<BR><BR>I have =
2=20
  postgreSQL databases called "DATA1" and "DATA2" with several tables =
inside=20
  them (table A, B, C). <BR><BR>I modify the details in table "A" in =
database=20
  "DATA1" <BR><BR>How can I copy table "A" from database "DATA1" and =
paste it in=20
  database "DATA2" using the same table name ??<BR><BR>Thank you.</FONT> =
</DIV>
  <DIV>
  <P><FONT face=3D"Verdana, Arial, Helvetica, sans-serif" =
color=3D#ff66cc=20
  size=3D2></FONT>&nbsp;</P></DIV></BLOCKQUOTE></BODY></HTML>

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