Re: pg_dump and search_path - Mailing list pgsql-general

On 7/9/19 6:28 AM, Ron wrote:

> 
> Then should search_path be set at the end of pg_restore?
> 

1) That would be to late for anything happening in the restore.

2) The:

SELECT pg_catalog.set_config('search_path', '', false);

only applies to the restore session. After the restore the search_path 
will return to whatever has been configured.



-- 
Adrian Klaver
adrian.klaver@aklaver.com