On Wednesday, August 24, 2022, gzh <
gzhcoder@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.