Ray Stell <stellr@xxxxxxxxxx> writes: > The doc for pg_dump --clean says it will drop db objects, not the db, > however it looks like it does, though the output order of events is > troubling. Is there a loop in the create/drop area?. "strings" is not the way to find out what will be emitted by pg_restore. (Hint: there are commands in the dump archive that may or may not be used by pg_restore.) Use a plain pg_dump command, or equivalently look at pg_restore's output script. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly