From: Richard Huxton <dev@archonet.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: to restore database in schema
Date: Fri, 28 Sep 2007 11:19:26 +0100
Message-ID: <46FCD52E.5080604@archonet.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C909EA5C30@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C909EA5C30@venus.infics.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, penchalaiahp@infics.com
Subject: Re: to restore database in schema
In-Reply-To: <46FCD52E.5080604@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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