pg_dump -n schema -Fc has a DROP DATABASE command... confused

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:

Screen Shot 2022-01-20 at 8.40.24 PM.png

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?

Doing a text dump w/o -Fc yields a text file with no DROP statement.

More just curious, less afraid at this point.

--

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux