Rename Schema or Script DDL only a schema

From: "kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Rename Schema or Script DDL only a schema
Date: 2004-04-06 09:02:04
Message-ID: 01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message SZŰCS Gábor 2004-04-06 13:12:46 could not devise a query plan
Previous Message Olivier Hubaut 2004-04-06 08:17:49 Re: Rename Schema or Script DDL only a schema