pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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