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