Re: pg_restore remap schema
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Fabrice Chapuis <fabrice636861@gmail.com>,
"pgsql-generallists.postgresql.org"
<pgsql-general@lists.postgresql.org>
Date: 2022-08-08T18:22:42Z
Lists: 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