Re:Re: pg_dump without setting search_path

2022-08-24 Thread gzh
Dear all, Thank you so much for your response to my request for information. I appreciated you taking the time to provide some answers and for getting back to me so promptly. It made a lot of sense and was exactly what I needed to know. At 2022-08-25 12:19:03, "Adrian Klaver" wrote: >On 8/24/

Re:Re: pg_dump without setting search_path

2022-08-24 Thread gzh
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? A