Thread: How Copy 7.3 Schemas?

How Copy 7.3 Schemas?

From
"Lex"
Date:

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:
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 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

--
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.