Commitc09f1dc

committed

Improve documentation about pg_dump's --quote-all-identifiers switch.

Per bug #14152 from Alejandro Martínez. Back-patch to all supportedbranches.Discussion: <20160520165824.22598.31426@wrigleys.postgresql.org>

1 parent9312c04 commitc09f1dcCopy full SHA for c09f1dc

File tree

+20

-6

lines changed

+20

-6

lines changed

Lines changed: 10 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -817,9 +817,16 @@ PostgreSQL documentation`
`817`	`817`	`<term><option>--quote-all-identifiers</></term>`
`818`	`818`	`<listitem>`
`819`	`819`	`<para>`
`820`		`- Force quoting of all identifiers. This may be useful when dumping a`
`821`		`- database for migration to a future version that may have introduced`
`822`		`- additional keywords.`
	`820`	`+ Force quoting of all identifiers. This option is recommended when`
	`821`	`+ dumping a database from a server whose <productname>PostgreSQL</>`
	`822`	`+ major version is different from <application>pg_dump</>'s, or when`
	`823`	`+ the output is intended to be loaded into a server of a different`
	`824`	`+ major version. By default, <application>pg_dump</> quotes only`
	`825`	`+ identifiers that are reserved words in its own major version.`
	`826`	`+ This sometimes results in compatibility issues when dealing with`
	`827`	`+ servers of other versions that may have slightly different sets`
	`828`	`+ of reserved words. Using <option>--quote-all-identifiers</> prevents`
	`829`	`+ such issues, at the price of a harder-to-read dump script.`
`823`	`830`	`</para>`
`824`	`831`	`</listitem>`
`825`	`832`	`</varlistentry>`

Lines changed: 10 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -368,9 +368,16 @@ PostgreSQL documentation`
`368`	`368`	`<term><option>--quote-all-identifiers</></term>`
`369`	`369`	`<listitem>`
`370`	`370`	`<para>`
`371`		`- Force quoting of all identifiers. This may be useful when dumping a`
`372`		`- database for migration to a future version that may have introduced`
`373`		`- additional keywords.`
	`371`	`+ Force quoting of all identifiers. This option is recommended when`
	`372`	`+ dumping a database from a server whose <productname>PostgreSQL</>`
	`373`	`+ major version is different from <application>pg_dumpall</>'s, or when`
	`374`	`+ the output is intended to be loaded into a server of a different`
	`375`	`+ major version. By default, <application>pg_dumpall</> quotes only`
	`376`	`+ identifiers that are reserved words in its own major version.`
	`377`	`+ This sometimes results in compatibility issues when dealing with`
	`378`	`+ servers of other versions that may have slightly different sets`
	`379`	`+ of reserved words. Using <option>--quote-all-identifiers</> prevents`
	`380`	`+ such issues, at the price of a harder-to-read dump script.`
`374`	`381`	`</para>`
`375`	`382`	`</listitem>`
`376`	`383`	`</varlistentry>`

Comments

(0)