Re: pg_dump without setting search_path

[David G. Johnston]

On Wednesday, August 24, 2022, gzh <gzhco...@126.com> wrote:
>
> When I use pg_dump to export schema from an older version of PostgreSQL
> 8.2.3 , it adds the following line at the beginning:
>
> SET search_path = public, pg_catalog;
>
> Is it possible set an option where pg_dump will add this line in
> PostgreSQL 12.5?
>
Your observation about the past isn’t going to change the answer
(especially if you choose to appeal to 8.2 behavior).  It is a policy
choice, not a technical limitation.

David J.