sed is a solution for making substitutions on plain text. But if we work with directory mode to use parallelism, I don't see how to proceed to make a schema remap. Editing the toc file in text mode does not work neither.
Regards,
Fabrice
On Mon, Aug 8, 2022 at 9:27 PM Marcos Pegoraro <marcos@f10.com.br> wrote:
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 :-)
Another 95% solution, if both schemas are on the same server, google for function clone schema, you´ll find some of them. They create tables, functions, sequences, views, ...