Christopher Kings-Lynne <[EMAIL PROTECTED]> 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

I seem to recall that there was some reason for using "", but I don't
recall what exactly.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to