Thread: Rename Schema or Script DDL only a schema

Rename Schema or Script DDL only a schema

From
"kumar"
Date:
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

Re: Rename Schema or Script DDL only a schema

From
"Olivier Hubaut"
Date:
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