Обсуждение: to restore database in schema

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. If you 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