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--