Re: [SQL] Rename Schema or Script DDL only a schema

2004-04-06 Thread Olivier Hubaut
On Tue, 6 Apr 2004 14:32:04 +0530, kumar <[EMAIL PROTECTED]> 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

[SQL] Rename Schema or Script DDL only a schema

2004-04-06 Thread kumar
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