Re: pg_restore remap schema - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore remap schema
Date
Msg-id 1343019.1668611420@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore remap schema  (Stéphane Tachoires <stephane.tachoires@gmail.com>)
List pgsql-general
=?UTF-8?Q?St=C3=A9phane_Tachoires?= <stephane.tachoires@gmail.com> writes:
> And could it be at pg_dump level ?
> It seems more aware of what is doing...

pg_dump would be in a slightly better position, but only slightly.
It still has no idea about the contents of function bodies.

Also, if it's acceptable to do this at dump time, you could just
temporarily rename the schema on the server while making the dump.
(Not that that would fix function bodies either.)

            regards, tom lane



pgsql-general by date:

Previous
From: Stéphane Tachoires
Date:
Subject: Re: pg_restore remap schema
Next
From: Thomas Kellerer
Date:
Subject: Re: pg_restore remap schema