Re: [SQL] to restore database in schema

2007-09-28 Thread Richard Huxton
Penchalaiah P. wrote: Hi ... Under one database who's name is postgres ,its contains 2 schema's Probably not a good idea to use the "postgres" database for casual usage. Any reason why you're not using a new database? 1)cdao1 2)cdao2. OK I want to restore one database into schema 2.(cd

[SQL] to restore database in schema

2007-09-28 Thread Penchalaiah P.
Hi ... Under one database who's name is postgres ,its contains 2 schema's 1)cdao1 2)cdao2. I want to restore one database into schema 2.(cdao2)...here there is no option to restore... I can restore into one database,but I cant restore into schema...may I know y its happening... Any one can