Thread: Rename Schema or Script DDL only a schema
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
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