diff options
| author | Thomas Munro <tmunro@postgresql.org> | 2018-07-13 13:57:03 +1200 |
|---|---|---|
| committer | Thomas Munro <tmunro@postgresql.org> | 2018-07-13 13:57:03 +1200 |
| commit | 387a5cfb94f041ffe18d03ccc4063c626bb4b73e (patch) | |
| tree | 74d9a05a3c9412514f129dc6ad551e2f55e3b294 /doc/src | |
| parent | ce89ad0fa07d98e20380867811a5269ee36d45c7 (diff) | |
Add pg_dump --on-conflict-do-nothing option.
When dumping INSERT statements, optionally add ON CONFLICT DO NOTHING.
Author: Surafel Temesgen
Reviewed-by: Takeshi Ideriha, Nico Williams, Dilip Kumar
Discussion: https://postgr.es/m/CALAY4q-PQ9cOEzs2%2BQHK5ObfF_4QbmBaYXbZx6BGGN66Q-n8FA%40mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 12 |
2 files changed, 24 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index f402d46b0cf..8286b2dddda 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -910,6 +910,18 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--on-conflict-do-nothing</option></term> + <listitem> + <para> + Add <literal>ON CONFLICT DO NOTHING</literal> to + <command>INSERT</command> commands. + This option is not valid unless <option>--inserts</option> or + <option>--column-inserts</option> is also specified. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--quote-all-identifiers</option></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 22cb7907035..94d76c30db3 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -447,6 +447,18 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--on-conflict-do-nothing</option></term> + <listitem> + <para> + Add <literal>ON CONFLICT DO NOTHING</literal> to + <command>INSERT</command> commands. + This option is not valid unless <option>--inserts</option> or + <option>--column-inserts</option> is also specified. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--quote-all-identifiers</option></term> <listitem> <para> |