On 9/5/19 7:35 AM, Tom Lane wrote:
Lele Gaifax <lele@xxxxxxxxxxxxxxx> writes:
I'm hitting a problem very similar to the one described here[1]
pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '', false);//' | psql targetdb
There's been some discussion of providing a simpler way to do this,
but nothing's been done about that either.
My 2 cents would be for a --unsecure-path option to pg_dump/restore that
would drop the pg_catalog.set_config('search_path', '', false).
regards, tom lane
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
