Re: pg_restore remap schema - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore remap schema
Date
Msg-id 645026.1659982962@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore remap schema  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: pg_restore remap schema
Re: pg_restore remap schema
Re: pg_restore remap schema
List pgsql-general
Guillaume Lelarge <guillaume@lelarge.info> writes:
> Le lun. 8 août 2022 à 18:28, Fabrice Chapuis <fabrice636861@gmail.com> a
>> Is a development in progress to add this option

> Nope, never heard of someone working on this.

People have asked for such a thing before, but it'd be quite difficult
to do reliably --- particularly inside function bodies, which aren't
normally parsed at all during a dump/restore.  If you're willing to
accept a 95% solution, running the pg_restore output through "sed"
would likely work fairly well.  I'd personally want to diff the
before-and-after scripts before applying though :-)

            regards, tom lane



pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: pg_restore remap schema
Next
From: Marcos Pegoraro
Date:
Subject: Re: pg_restore remap schema