Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> When running pg_dump --clean against a server that doesn't have schemas
>> the namespace is blank and ends up producing a dump full off things like:
>>
>> DROP TABLE "".tab;
> Since the person is dumping using 7.5 pg_dump, presumably they will be
> restoring to 7.5, and it should be:
> DROP TABLE "public".tab;
Possibly the most correct solution is to assign the name "public" to the
dummy schema that pg_dump creates internally when talking to a pre-7.3
server.
I seem to recall that there was some reason for using "", but I don't
recall what exactly.
regards, tom lane