Re:Re: pg_dump without setting search_path
| От | gzh |
|---|---|
| Тема | Re:Re: pg_dump without setting search_path |
| Дата | |
| Msg-id | 84f48ce.353d.182d3926553.Coremail.gzhcoder@126.com обсуждение исходный текст |
| Ответ на | Re: pg_dump without setting search_path (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
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" <adrian.klaver@aklaver.com> wrote: >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.klaver@aklaver.com
В списке pgsql-general по дате отправления: