Horton
Menu

Re: pg_restore remap schema

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stéphane Tachoires <stephane.tachoires@gmail.com>
Cc: Guillaume Lelarge <guillaume@lelarge.info>, Fabrice Chapuis <fabrice636861@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>, Marcos Pegoraro <marcos@f10.com.br>
Date: 2022-11-16T15:10:20Z
Lists: 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