Re: pg_restore remap schema

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Subject: Re: pg_restore remap schema
Date: 2022-11-16 13:36:15
Message-ID: CAECtzeVznWO98VQyxN8KH24LOcx8UtxoqtLEoKiaowzDnDJ1MA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Le mer. 16 nov. 2022 à 13:08, Fabrice Chapuis <fabrice636861(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shashidhar Reddy 2022-11-16 13:48:36 Re: unrecognized node type: 350
Previous Message Daniel Gustafsson 2022-11-16 12:56:43 Re: unrecognized node type: 350