Thread: How Copy 7.3 Schemas?

How Copy 7.3 Schemas?

From

"Lex"

Date:

15 January 2003, 10:39:54

I am playing with the new Schema feature in 7.3. I would like to copy the public schema into a new schema. Is there an easy way to do this? Something I can do with pg_dump (I don’t see a switch to specify which schema) Right now I an only interested in copying the structures – later on it would be nice if I could copy the data as well.

Regards

Re: How Copy 7.3 Schemas?

From

"Rajesh Kumar Mallah."

Date:

16 January 2003, 05:04:37

A drity method could be.
create table schema2.table2 as select * from schema1.table1 ;
in a loop that uses system catalogs.


regds
mallah.





On Wednesday 15 January 2003 06:08 pm, Lex wrote:
> I am playing with the new Schema feature in 7.3.  I would like to copy
> the public schema into a new schema.  Is there an easy way to do this?
> Something I can do with pg_dump (I dont see a switch to specify which
> schema)  Right now I an only interested in copying the structures 
> later on it would be nice if I could copy the data as well.
>
>
>
> Regards

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.