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 BC74BD1CCC1 for ; Tue, 6 Apr 2004 06:17:15 -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 39335-01 for ; Tue, 6 Apr 2004 06:17:54 -0300 (ADT) Received: from guppy.vub.ac.be (guppy.vub.ac.be [134.184.129.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6E701D1ED0B for ; Tue, 6 Apr 2004 06:17:07 -0300 (ADT) Received: from mach.vub.ac.be (mach.vub.ac.be [134.184.129.8]) by guppy.vub.ac.be (8.9.1b+Sun/3.17.1.ap (guppy)) id LAA28364; Tue, 6 Apr 2004 11:17:52 +0200 (MET DST) for Received: from olivier.amaze.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (Postfix) with ESMTP id 11D4622DD; Tue, 6 Apr 2004 11:17:49 +0200 (CEST) To: kumar , pgsql Subject: Re: Rename Schema or Script DDL only a schema References: <01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com> Message-ID: From: "Olivier Hubaut" Organization: SCMBB Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Date: Tue, 06 Apr 2004 11:17:49 +0300 In-Reply-To: <01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com> User-Agent: Opera M2/7.50 (MacPPC, build 1701) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/32 X-Sequence-Number: 17407 On Tue, 6 Apr 2004 14:32:04 +0530, kumar wrote: > 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 only the schema. > > Else, it possible to rename the schema. > > Please shed some light. > > Thanks > Kumar Not with this version of PG. v7.4 allows you to rename schema and dump specific schemas. -- Downloading signature ... 99% *CRC FAILED* signature aborted