PG Bug reporting form <noreply(at)postgresql(dot)org> writes:> I’m experiencing some weird behaviour of pg_dump: based on this thread> https://www.postgresql.org/message-id/flat/20849.1541638465%40sss.pgh.pa.us#744c293b37793dea0f6e60676c3f3210> , starting from v11 pg_dump should not include CREATE SCHEMA public> statements to the dump. However, if I run pg_dump v12 with --schema public ,> it still adds that line to the backup file,
Our interpretation of that is that you've deliberately selected theschema, so it should be dumped.
> which breaks the ability to> restore from it
That's rather an overstatement no? You can just ignore the "alreadyexists" error.
regards, tom lane