On 8/24/22 20:39, gzh wrote:
Hi Tom,Thank you for your prompt response.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?
No for this reason: https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path
regards, tom lane
-- Adrian Klaver adrian.kla...@aklaver.com
