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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
