diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 14 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 11 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 14 |
3 files changed, 37 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 40c69f05421..1f0d4ded32e 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -145,7 +145,8 @@ PostgreSQL documentation <para> Output commands to clean (drop) database objects prior to outputting the commands for creating them. - (Restore might generate some harmless error messages, if any objects + (Unless <option>--if-exists</> is also specified, + restore might generate some harmless error messages, if any objects were not present in the destination database.) </para> @@ -650,6 +651,17 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--if-exists</option></term> + <listitem> + <para> + Use conditional commands (i.e. add an <literal>IF EXISTS</literal> + clause) when cleaning database objects. This option is not valid + unless <option>--clean</> is also specified. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--disable-dollar-quoting</></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index f33793985f9..fcf5f77a6db 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -301,6 +301,17 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--if-exists</option></term> + <listitem> + <para> + Use conditional commands (i.e. add an <literal>IF EXISTS</literal> + clause) to clean databases and other objects. This option is not valid + unless <option>--clean</> is also specified. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--inserts</option></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index cd60b2558a4..4bc30ce679b 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -109,7 +109,8 @@ <listitem> <para> Clean (drop) database objects before recreating them. - (This might generate some harmless error messages, if any objects + (Unless <option>--if-exists</> is used, + this might generate some harmless error messages, if any objects were not present in the destination database.) </para> </listitem> @@ -490,6 +491,17 @@ </varlistentry> <varlistentry> + <term><option>--if-exists</option></term> + <listitem> + <para> + Use conditional commands (i.e. add an <literal>IF EXISTS</literal> + clause) when cleaning database objects. This option is not valid + unless <option>--clean</> is also specified. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--no-data-for-failed-tables</option></term> <listitem> <para> |