Re: pg_dump fail to not dump public schema orders

2020-05-29 Thread David G. Johnston
On Fri, May 29, 2020 at 7:42 AM Adrien Nayrat wrote: > On 5/29/20 3:56 PM, David G. Johnston wrote: > > On Friday, May 29, 2020, Adrien Nayrat > > wrote: > > > > Hello, > > > > I noticed pg_dump failed to not dump creation or comment commands > for publ

Re: pg_dump fail to not dump public schema orders

2020-05-29 Thread Adrien Nayrat
On 5/29/20 3:56 PM, David G. Johnston wrote: > On Friday, May 29, 2020, Adrien Nayrat > wrote: > > Hello, > > I noticed pg_dump failed to not dump creation or comment commands for > public > schema when we explicitly ask it to dump public schema. >

Re: pg_dump fail to not dump public schema orders

2020-05-29 Thread Tom Lane
"David G. Johnston" writes: > On Friday, May 29, 2020, Adrien Nayrat wrote: >> I noticed pg_dump failed to not dump creation or comment commands for >> public schema when we explicitly ask it to dump public schema. > As far as I can tell this is working as intended/documented. The public > sche

Re: pg_dump fail to not dump public schema orders

2020-05-29 Thread David G. Johnston
On Friday, May 29, 2020, Adrien Nayrat wrote: > Hello, > > I noticed pg_dump failed to not dump creation or comment commands for > public > schema when we explicitly ask it to dump public schema. > > Shorter example: pg_dump -n public dump will give: > [Create schema public] > As far as I

pg_dump fail to not dump public schema orders

2020-05-29 Thread Adrien Nayrat
Hello, I noticed pg_dump failed to not dump creation or comment commands for public schema when we explicitly ask it to dump public schema. Shorter example: pg_dump -n public dump will give: -- -- Name: public; Type: SCHEMA; Schema: -; Owner: postgres -- CREATE SCHEMA public; ALTER SCHEMA pub