Re: pg_dump fail to not dump public schema orders

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: Adrien Nayrat <adrien.nayrat@anayrat.info>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2020-05-29T13:56:36Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Improve pg_dump's handling of "special" built-in objects.
- 5955d934194c 11.0 cited

On Friday, May 29, 2020, Adrien Nayrat <adrien.nayrat@anayrat.info> 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 can tell this is working as intended/documented.  The public
schema doesn’t and doesn’t and shouldn’t get special treatment relative to
any other user schema here.

David J.