Re: pg_restore creates public schema?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2022-10-06T14:49:31Z
Lists: pgsql-general
Ron <ronljohnsonjr@gmail.com> writes:
> pg_dump 9.6.24

You realize that that version's been out of support for a year?

> Why does pg_restore explicitly create "public" even though public is 
> automatically created when the database is created?

We fixed that in v11 (see 5955d9341).  Evidently the fix requires an
updated pg_dump more than pg_restore.  However, I believe that only
happens with -c, so why are you using both -c and -C?

			regards, tom lane