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.