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 3A6CED7693 for ; Fri, 14 Oct 2005 05:44:21 -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 13089-02 for ; Fri, 14 Oct 2005 08:44:17 +0000 (GMT) Received: from smtpout13.attiva.biz (smtpout13.attiva.biz [85.37.16.15]) by svr1.postgresql.org (Postfix) with ESMTP id 3EA15D70B9 for ; Fri, 14 Oct 2005 05:44:18 -0300 (ADT) Received: from FBCMFE02B06.fbc.local ([192.168.30.94]) by smtpout13.attiva.biz with Microsoft SMTPSVC(6.0.3790.211); Fri, 14 Oct 2005 10:45:03 +0200 Received: from dream ([81.74.60.30]) by FBCMFE02B06.fbc.local with Microsoft SMTPSVC(6.0.3790.211); Fri, 14 Oct 2005 10:45:02 +0200 Message-ID: <004801c5d09b$747fad80$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: copy table Date: Fri, 14 Oct 2005 10:44:13 +0200 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01C5D0AC.37B9E850" 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 08:45:02.0118 (UTC) FILETIME=[9100BC60:01C5D09B] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.435 required=5 tests=[AWL=0.434, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/154 X-Sequence-Number: 23007 This is a multi-part message in MIME format. ------=_NextPart_000_0045_01C5D0AC.37B9E850 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello How can i copy a table from one schema to another.. Example.. * I have a database "mydatabase" * then i have 2 schemas "myschema1" and "myschema2" * in "myschema1" i have inserted a new line and i want to copy that to = "myschema2" so they both will be same..=20 How can i do it with SQL ??=20 I use pgadmin 3 to make my database in postgresql thank u ------=_NextPart_000_0045_01C5D0AC.37B9E850 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello
 
How can i copy a table from one schema = to=20 another..
 
Example..
 
* I have a database = "mydatabase"
* then i have 2 schemas "myschema1" and = "myschema2"
* in "myschema1" i have inserted a new = line and i=20 want to copy that to "myschema2" so they both will be same.. =
 
How can i do it with SQL ?? =
 
I use pgadmin 3 to make my = database=20 in postgresql
 
thank u
------=_NextPart_000_0045_01C5D0AC.37B9E850--