Wells Oliver <wells.oliver@xxxxxxxxx> writes: > I did a few pg_dumps of different schemas using: > pg_dump -h host dbname -n schema -Fc > schema.dump > Opening it in VIM brings up a binary file (compressed, sure) but it looks > like this: > Which contains the line "DROP DATABASE". Which is weird-- it does not drop > the database, I mean, I restored from the same file. Why is this in there? pg_dump -Fc produces an archive file that pg_restore can use to do whatever you can ask pg_restore to do. One of those things is the --clean switch, which says to drop every database object before restoring. So among the strings in the archive file you will find DROP commands for all the dumped objects. Those are not issued by default, though. (The other DROP commands might be obscured by compression. Try --compress=0 to get a clearer view of what's in there.) regards, tom lane
