Postgres Pro
Downloads
Home   >   mailing lists

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

From kumar
Subject Rename Schema or Script DDL only a schema
Date
Msg-id 01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com
Whole thread Raw
Responses Re: Rename Schema or Script DDL only a schema  ("Olivier Hubaut" <olivier@scmbb.ulb.ac.be>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Entered data appears TWICE in table!!?
Next
From: "Olivier Hubaut"
Date:
Subject: Re: Rename Schema or Script DDL only a schema