Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 682436340C1 for ; Thu, 1 Apr 2010 12:06:30 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21118-05 for ; Thu, 1 Apr 2010 15:06:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from madmax.bizintegrators.com (madmax.bizintegrators.com [64.94.184.54]) by mail.postgresql.org (Postfix) with ESMTP id 339C3633DC4 for ; Thu, 1 Apr 2010 12:06:17 -0300 (ADT) Received: from shelca (p65-147.acedsl.com [66.114.65.147]) (authenticated bits=0) by madmax.bizintegrators.com (8.13.4/8.13.4) with ESMTP id o31F6DkD028384 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 1 Apr 2010 11:06:14 -0400 (EDT) References: <30B673D7B5844B4394E188D9FFAEF0990160F94B@mx01.corp.castsoftware.com> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Christophe Dore Cc: pgsql-admin@postgresql.org Subject: Re: pg_restore : change schema Date: Thu, 01 Apr 2010 11:06:43 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Loftmail-Check: No X-Scanned-By: MIMEDefang 2.57 on 64.94.184.88 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.916 tagged_above=-10 required=5 tests=AWL=0.683, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201004/4 X-Sequence-Number: 34098 Christophe Dore writes: > Imagine I have used pg_dump to backup a given single schema. > Is there any feature in pg_restore (8.4) that would allow to restore this > schema in a schema with another name ? I think there isn't. If the pg_dump is ASCII and the file is small enough you could edit it.