Re: pg_restore remap schema

Guillaume Lelarge <guillaume@lelarge.info>

From: Guillaume Lelarge <guillaume@lelarge.info>
To: Fabrice Chapuis <fabrice636861@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>, Marcos Pegoraro <marcos@f10.com.br>
Date: 2022-11-16T13:36:15Z
Lists: pgsql-general
Hi,

Le mer. 16 nov. 2022 à 13:08, Fabrice Chapuis <fabrice636861@gmail.com> a
écrit :

> Hi,
> I worked on the pg_dump source code to add remap schema functionality to
> use it internally where I work. This is a first version that allows to
> remap tables, views and sequences (only to export schema). Is this
> development likely to interest the PG community and to continue this
> development further?
>
>
If it doesn't work on functions, that will be a big issue. And to be
honest, I don't think you can do it reliably on functions, especially with
dynamic queries in PL/pgsql.

Though it would still be interesting to see your patch.


-- 
Guillaume.