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 server. 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]