Opened question about pg_dump/pg_restore behaviour when (not) specifying database schema recently, I had to dump a postgresql database by doing: