John Bercik <bercikj(at)musc(dot)edu> writes:
> I'm in PG 8.0b3 and in it's psql i perform an -Fc pg_dump on a 7.4 db.
> When I go to restore in PG 8.0b3 I get errors because of schemas that
> have capital letters ("EMRImporting"). It creates schema "emrimporting"
> and fails upon trying to restore data to "EMRImporting" schema because
> it doesn't exist. Thanks for any help.
Can you give us a complete example? I don't see any unquoted schema
names in a quick test.
regards, tom lane