Re: pg_dump --clean or dropdb? - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump --clean or dropdb?
Date
Msg-id 14924.1203623407@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump --clean or dropdb?  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
Ray Stell <stellr@cns.vt.edu> 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

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: pg_dump --clean or dropdb?
Next
From: Carol Walter
Date:
Subject: Re: Stable Release?