X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EE269D1E828 for ; Tue, 6 Apr 2004 06:01:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24557-08 for ; Tue, 6 Apr 2004 06:01:52 -0300 (ADT) Received: from chn-dns.primus-india.net (chn-dns.primus-india.net [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id C20AFD1E85C for ; Tue, 6 Apr 2004 06:01:04 -0300 (ADT) Received: from ivesia67 (ptil-138-190-chn.primus-india.net [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id i3682DJk029136 for ; Tue, 6 Apr 2004 13:32:23 +0530 Message-ID: <01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com> From: "kumar" To: "pgsql" Subject: Rename Schema or Script DDL only a schema Date: Tue, 6 Apr 2004 14:32:04 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01E9_01C41BE3.EE3A70B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/31 X-Sequence-Number: 17406 This is a multi-part message in MIME format. ------=_NextPart_000_01E9_01C41BE3.EE3A70B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, Postgres 7.3.2 on Linux 8. I wanna move about 100 tables from one schema to another (within a database= ). Is possible to do that? Seems pg_dump doesnt have an option to script on= ly the schema. Else, it possible to rename the schema. Please shed some light. Thanks Kumar ------=_NextPart_000_01E9_01C41BE3.EE3A70B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
Postgres 7.3.2 on Linux 8.
 
I wanna move about 100 tables from one sch= ema to=20 another (within a database). Is possible to do that? Seems pg_dump doesnt h= ave=20 an option to script only the schema.
 
Else, it possible to rename the=20 schema.
 
Please shed some light.
 
Thanks
Kumar
------=_NextPart_000_01E9_01C41BE3.EE3A70B0--