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 help me for this



Thanks & Regards

Penchal Reddy



Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is
intended for use only by the individual or the entity to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law. Ifyou are not the intended recipient or it
appears that this mail has been forwarded to you without proper authority,you are notified that any use or dissemin-
ation of this information in any manner is strictly prohibited.In such cases,please notify us immediately at
info.in@infics.com and delete this email from your records.

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.(cdao2)...here there is no
> option to restore...

You want to restore what database? A database can contain multiple
schemas, so I'm not sure how you'd restore a DB "into" a schema?

Are you trying to copy schema cdao1 into cdao2?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq