From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused
In-reply-to: 
 <CAOC+FBWrBPQOeL5_BXL2Xypr9aoJ56fbLsusyM7GU=5nXXaB_Q@mail.gmail.com>
References: 
 <CAOC+FBWrBPQOeL5_BXL2Xypr9aoJ56fbLsusyM7GU=5nXXaB_Q@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Thu, 20 Jan 2022 20:44:26 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1123449.1642741378.1@sss.pgh.pa.us>
Date: Fri, 21 Jan 2022 00:02:58 -0500
Message-ID: <1123450.1642741378@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1123450.1642741378%40sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.com> 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