pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
RESTORE SCHEMA
2+ messages / 2 participants
[nested] [flat]

* RESTORE SCHEMA
@ 2007-01-23 08:00 Kranti <kranti.j2ee@gmail.com>
  2007-01-23 08:21 ` Re: RESTORE SCHEMA Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Kranti @ 2007-01-23 08:00 UTC (permalink / raw)
  To: pgsql-admin; +Cc: kranti.parisa@gmail.com

Hey Guys,

This is my first email to list. Hope i will get the solution quickly.
I am working on postgresql 8.1

I have  a DB, with mre than 4 schemas.  I want to take backup of one of the
schema and restore the same schema into another DB .ofcourse schema names
are same.

I am able to take backup and restore at DB level.
but i want the same at schema level.

Using pgadmin III i am able to take backup of schema. but not able to see
restore of that schema.

I am in a very urgent need. Please do respond to this and guide me

Thanks in advance
Kranti

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: RESTORE SCHEMA
  2007-01-23 08:00 RESTORE SCHEMA Kranti <kranti.j2ee@gmail.com>
@ 2007-01-23 08:21 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Rajesh Kumar Mallah @ 2007-01-23 08:21 UTC (permalink / raw)
  To: Kranti <kranti.j2ee@gmail.com>; +Cc: pgsql-admin; kranti.parisa@gmail.com

On 1/23/07, Kranti <kranti.j2ee@gmail.com> wrote:
> Hey Guys,
>
> This is my first email to list. Hope i will get the solution quickly.

Hi,
please use pg_dump -n option to select schema. Read manual
pages of pg_dump.I am not sure how to do it in pgadminIII
all said it is doable.

regds
malah.

> I am working on postgresql 8.1
>
> I have  a DB, with mre than 4 schemas.  I want to take backup of one of the
> schema and restore the same schema into another DB .ofcourse schema names
> are same.
>
> I am able to take backup and restore at DB level.
> but i want the same at schema level.
>
> Using pgadmin III i am able to take backup of schema. but not able to see
> restore of that schema.
>
> I am in a very urgent need. Please do respond to this and guide me
>
> Thanks in advance
> Kranti



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-01-23 08:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-23 08:00 RESTORE SCHEMA Kranti <kranti.j2ee@gmail.com>
2007-01-23 08:21 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.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