Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4C3939FB26E for ; Tue, 23 Jan 2007 04:21:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 89401-01 for ; Tue, 23 Jan 2007 04:21:16 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id C52F09FA354 for ; Tue, 23 Jan 2007 04:21:18 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so151030nfb for ; Tue, 23 Jan 2007 00:21:17 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=B1CNLXUB3WC/wN729dUugk4c2IBvf16fzYT1XYWznIE908yUPweiE2M6ugqrUD+/ZFSzfC670juq4MYhwXkjW9psVfDmneKv01bosn8A4lTp1O+ckBvjjhua4MJ9Ddru89akgHvU5xx7yr0D5SwXEiMwjiqWekSoXlvrU7DKF3c= Received: by 10.48.202.11 with SMTP id z11mr672994nff.1169540477257; Tue, 23 Jan 2007 00:21:17 -0800 (PST) Received: by 10.48.213.16 with HTTP; Tue, 23 Jan 2007 00:21:17 -0800 (PST) Message-ID: Date: Tue, 23 Jan 2007 13:51:17 +0530 From: "Rajesh Kumar Mallah" To: Kranti Subject: Re: RESTORE SCHEMA Cc: pgsql-admin@postgresql.org, kranti.parisa@gmail.com In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/209 X-Sequence-Number: 24365 On 1/23/07, Kranti 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