Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db - Mailing list pgsql-bugs

On 6/15/2016 8:49 AM, Hans Buschmann wrote:
>
> Even the syntax (ALTER DATABASE xxxdb SET SEARCH PATH) suggests this
> to be part of the database and not of a session or the cluster.

that syntax is indeed stored with the database schema, and would be part
of a database dump.

you also can simply SET search_path 'somevalue';    and this applies
only to the current session, and wouldn't be part of the database


--
john r pierce, recycling bits in santa cruz