pg_dump et al: Add --if-exists option
Alvaro Herrera <alvherre@alvh.no-ip.org>
pg_dump et al: Add --if-exists option This option makes pg_dump, pg_dumpall and pg_restore inject an IF EXISTS clause to each DROP command they emit. (In pg_dumpall, the clause is not added to individual objects drops, but rather to the CREATE DATABASE commands, as well as CREATE ROLE and CREATE TABLESPACE.) This allows for a better user dump experience when using --clean in case some objects do not already exist. Per bug #7873 by Dave Rolsky. Author: Pavel Stěhule Reviewed-by: Jeevan Chalke, Álvaro Herrera, Josh Kupershmidt
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/pg_dumpall.sgml | modified | +11 −0 |
| doc/src/sgml/ref/pg_dump.sgml | modified | +13 −1 |
| doc/src/sgml/ref/pg_restore.sgml | modified | +13 −1 |
| src/bin/pg_dump/pg_backup_archiver.c | modified | +71 −2 |
| src/bin/pg_dump/pg_backup.h | modified | +1 −0 |
| src/bin/pg_dump/pg_dumpall.c | modified | +19 −3 |
| src/bin/pg_dump/pg_dump.c | modified | +7 −0 |
| src/bin/pg_dump/pg_restore.c | modified | +11 −0 |