Re: pg_restore: error: schema "public" already exists

2020-10-27 Thread Tom Lane
raf writes: > A colleague is getting this error when trying to load a > database dump: > pg_restore: error: could not execute query: ERROR: schema "public" already > exists > I'm wondering if anyone can explain it. The public schema is a bit of a strange beast, and pg_dump has to special-case

pg_restore: error: schema "public" already exists

2020-10-27 Thread raf
Hi, A colleague is getting this error when trying to load a database dump: pg_restore: error: could not execute query: ERROR: schema "public" already exists I'm wondering if anyone can explain it. Here's the background. I have a "dump" script that calls pg_dump and pipes the output into gp