Re: pg_restore : change schema

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Christophe Dore <c(dot)dore(at)castsoftware(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore : change schema
Date: 2010-04-01 15:06:43
Message-ID: cone.1270134403.614462.18171.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Carey 2010-04-01 20:08:46 Re: Database size growing over time and leads to performance impact
Previous Message Jonathan Foy 2010-04-01 13:10:39 PD_ALL_VISIBLE flag warning