pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
to restore database in schema 2+ messages / 2 participants [nested] [flat]
* to restore database in schema @ 2007-09-28 10:00 Penchalaiah P. <penchalaiahp@infics.com> 0 siblings, 1 reply; 2+ messages in thread From: Penchalaiah P. @ 2007-09-28 10:00 UTC (permalink / raw) To: pgsql-sql 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. 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: to restore database in schema @ 2007-09-28 10:19 Richard Huxton <dev@archonet.com> parent: Penchalaiah P. <penchalaiahp@infics.com> 0 siblings, 0 replies; 2+ messages in thread From: Richard Huxton @ 2007-09-28 10:19 UTC (permalink / raw) To: Penchalaiah P. <penchalaiahp@infics.com>; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-09-28 10:19 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-09-28 10:00 to restore database in schema Penchalaiah P. <penchalaiahp@infics.com> 2007-09-28 10:19 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox