Обсуждение: How Copy 7.3 Schemas?
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
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.