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

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема pg_dump -n schema -Fc has a DROP DATABASE command... confused
Дата
Msg-id CAOC+FBWrBPQOeL5_BXL2Xypr9aoJ56fbLsusyM7GU=5nXXaB_Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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.

--
Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Password authorization
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused