Re: pg_dump --clean w/ <= 7.2 server

Kris Jurka <books@ejurka.com> writes:
>> 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 was considering that they might want to restore the dump into another
> schema and that would be easier with an unqualified name.  I don't really
> understand why the name needs to be fully qualified in the first place.

Because it's entirely too likely that you'll drop the wrong thing if you
issue an unqualified DROP.

            regards, tom lane