Thread: to restore database in schema

to restore database in schema

From
"Penchalaiah P."
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi …</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Under one database who’s name is postgres ,its contains 2 schema’s</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">1)cdao1</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">2)cdao2.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I want to restore one database into schema 2.(cdao2)…here there is no option to
restore…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">I can restore into one database,but I cant restore into schema…may I know y its
happening…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Any one can help me for this</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><strong><b><font face="Monotype Corsiva" size="3"><span
style="font-size:12.0pt;font-family:"MonotypeCorsiva"">Thanks & Regards</span></font></b></strong><p
class="MsoNormal"><strong><b><fontface="Monotype Corsiva" size="3"><span style="font-size:12.0pt;font-family:"Monotype
Corsiva"">PenchalReddy</span></font></b></strong><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font></div><pre>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.
</pre>

Re: to restore database in schema

From
Richard Huxton
Date:
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