Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1838F9FB1F5 for ; Tue, 23 Jan 2007 04:00:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 99047-10 for ; Tue, 23 Jan 2007 04:00:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.246]) by postgresql.org (Postfix) with ESMTP id 865FC9FA282 for ; Tue, 23 Jan 2007 04:00:32 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so535602ana for ; Tue, 23 Jan 2007 00:00:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:mime-version:content-type; b=sNWYqjIdySfBXefI6hNqzgosXyir4v9or6usIZTktiOAeGa+spVW5uOuWI712hA0wW6lmEUTQ8AG95v3/mH7S1BjC/u1IChb8QTA1N/6Qp3wSXJ0D4Q78q32gsy1t5QK0GnyPB5ixA8FxlJVga2sqpmjwGcSRUOhCJnMMkS8BRs= Received: by 10.78.106.3 with SMTP id e3mr178455huc.1169539230799; Tue, 23 Jan 2007 00:00:30 -0800 (PST) Received: by 10.78.184.9 with HTTP; Tue, 23 Jan 2007 00:00:30 -0800 (PST) Message-ID: Date: Tue, 23 Jan 2007 13:30:30 +0530 From: Kranti To: pgsql-admin@postgresql.org Subject: RESTORE SCHEMA Cc: kranti.parisa@gmail.com MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_158669_21439895.1169539230690" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.257 tagged_above=0 required=5 tests=BAYES_20, HTML_MESSAGE, SPF_PASS, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200701/208 X-Sequence-Number: 24364 ------=_Part_158669_21439895.1169539230690 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_158669_21439895.1169539230690 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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
------=_Part_158669_21439895.1169539230690--