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