]> granicus.if.org Git - postgresql/commit
pg_dump et al: Add --if-exists option
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 3 Mar 2014 18:02:18 +0000 (15:02 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 3 Mar 2014 18:02:18 +0000 (15:02 -0300)
commit9067310cc5dd590e36c2c3219dbf3961d7c9f8cb
treee459d434c156d80a8b51fba86308d637fce6bfac
parent34c6d9611d23178539ed09b8f2ce40c5788a21cb
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
doc/src/sgml/ref/pg_dump.sgml
doc/src/sgml/ref/pg_dumpall.sgml
doc/src/sgml/ref/pg_restore.sgml
src/bin/pg_dump/pg_backup.h
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dumpall.c
src/bin/pg_dump/pg_restore.c