Postgres Pro
Downloads
Home   >   mailing lists

Re: Rename Schema or Script DDL only a schema - Mailing list pgsql-sql

From Olivier Hubaut
Subject Re: Rename Schema or Script DDL only a schema
Date
Msg-id opr502rzcr94ope3@olivier.amaze.ulb.ac.be
Whole thread Raw
In response to Rename Schema or Script DDL only a schema  ("kumar" <sgnerd@yahoo.com.sg>)
List pgsql-sql
Tree view 
On Tue, 6 Apr 2004 14:32:04 +0530, kumar <sgnerd@yahoo.com.sg> 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

pgsql-sql by date:

Previous
From: "kumar"
Date:
Subject: Rename Schema or Script DDL only a schema
Next
From: "SZŰCS Gábor"
Date:
Subject: could not devise a query plan