postgres.git / summary / log / commit / refs
commit c09f1dcef3ed4f8a50fb6391d1894fa1d5634c03
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri May 20 18:59:48 2016 +0000
First released in: 9.6.0, 9.1.23, 9.2.18, 9.3.14, 9.4.9, 9.5.4
Improve documentation about pg_dump's --quote-all-identifiers switch.
Per bug #14152 from Alejandro MartÃnez. Back-patch to all supported
branches.
Discussion: <20160520165824.22598.31426@wrigleys.postgresql.org>
doc/src/sgml/ref/pg_dump.sgml | 13 ++++++++++---
doc/src/sgml/ref/pg_dumpall.sgml | 13 ++++++++++---
2 files changed, 20 insertions(+), 6 deletions(-)
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
index 1090daaa31b..7763f58b0b9 100644
--- a/doc/src/sgml/ref/pg_dump.sgml
+++ b/doc/src/sgml/ref/pg_dump.sgml
@@ -817,9 +817,16 @@ PostgreSQL documentation
<term><option>--quote-all-identifiers</></term>
<listitem>
<para>
- Force quoting of all identifiers. This may be useful when dumping a
- database for migration to a future version that may have introduced
- additional keywords.
+ Force quoting of all identifiers. This option is recommended when
+ dumping a database from a server whose <productname>PostgreSQL</>
+ major version is different from <application>pg_dump</>'s, or when
+ the output is intended to be loaded into a server of a different
+ major version. By default, <application>pg_dump</> quotes only
+ identifiers that are reserved words in its own major version.
+ This sometimes results in compatibility issues when dealing with
+ servers of other versions that may have slightly different sets
+ of reserved words. Using <option>--quote-all-identifiers</> prevents
+ such issues, at the price of a harder-to-read dump script.
</para>
</listitem>
</varlistentry>
diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml
index 6c34c257b3c..97168a08159 100644
--- a/doc/src/sgml/ref/pg_dumpall.sgml
+++ b/doc/src/sgml/ref/pg_dumpall.sgml
@@ -368,9 +368,16 @@ PostgreSQL documentation
<term><option>--quote-all-identifiers</></term>
<listitem>
<para>
- Force quoting of all identifiers. This may be useful when dumping a
- database for migration to a future version that may have introduced
- additional keywords.
+ Force quoting of all identifiers. This option is recommended when
+ dumping a database from a server whose <productname>PostgreSQL</>
+ major version is different from <application>pg_dumpall</>'s, or when
+ the output is intended to be loaded into a server of a different
+ major version. By default, <application>pg_dumpall</> quotes only
+ identifiers that are reserved words in its own major version.
+ This sometimes results in compatibility issues when dealing with
+ servers of other versions that may have slightly different sets
+ of reserved words. Using <option>--quote-all-identifiers</> prevents
+ such issues, at the price of a harder-to-read dump script.
</para>
</listitem>
</varlistentry>
[parent: 9312c04ac016]