On 5/29/20 3:56 PM, David G. Johnston wrote:
> On Friday, May 29, 2020, Adrien Nayrat <adrien.nayrat@anayrat.info
> <mailto: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.
>
I am not sure. See this comment from selectDumpableNamespace:
/*
* The public schema is a strange beast that sits in a sort of
* no-mans-land between being a system object and a user object. We
* don't want to dump creation or comment commands for it, because
* that complicates matters for non-superuser use of pg_dump. But we
* should dump any ACL changes that have occurred for it, and of
* course we should dump contained objects.
*/
FYI this behavior appeared with pg11. With pg10 you won't have "CREATE SCHEMA
public" orders.
Regards,