aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2023-10-31 10:21:31 -0400
committerBruce Momjian <bruce@momjian.us>2023-10-31 10:21:31 -0400
commitff81b9b7a74e147b4da730d6023fa69f461903fc (patch)
tree8cab0cbaf5c49f8840c500a00febea4364e3ae50
parentabf2c4499e59ff230ed12ccedd71442260784f79 (diff)
downloadpostgresql-ff81b9b7a74e147b4da730d6023fa69f461903fc.tar.gz
postgresql-ff81b9b7a74e147b4da730d6023fa69f461903fc.zip
doc: improve ALTER SYSTEM description of value list quoting
Reported-by: splarv@ya.ru Discussion: https://postgr.es/m/167105927893.1897.13227723035830709578@wrigleys.postgresql.org Backpatch-through: 11
-rw-r--r--doc/src/sgml/ref/alter_system.sgml10
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_system.sgml b/doc/src/sgml/ref/alter_system.sgml
index 5e41f7f6444..ab8d1502a7c 100644
--- a/doc/src/sgml/ref/alter_system.sgml
+++ b/doc/src/sgml/ref/alter_system.sgml
@@ -21,7 +21,7 @@ PostgreSQL documentation
<refsynopsisdiv>
<synopsis>
-ALTER SYSTEM SET <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> | '<replaceable class="parameter">value</replaceable>' | DEFAULT }
+ALTER SYSTEM SET <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> [, ...] | DEFAULT }
ALTER SYSTEM RESET <replaceable class="parameter">configuration_parameter</replaceable>
ALTER SYSTEM RESET ALL
@@ -82,9 +82,17 @@ ALTER SYSTEM RESET ALL
New value of the parameter. Values can be specified as string
constants, identifiers, numbers, or comma-separated lists of
these, as appropriate for the particular parameter.
+ Values that are neither numbers nor valid identifiers must be quoted.
<literal>DEFAULT</literal> can be written to specify removing the
parameter and its value from <filename>postgresql.auto.conf</filename>.
</para>
+
+ <para>
+ For some list-accepting parameters, quoted values will produce
+ double-quoted output to preserve whitespace and commas; for others,
+ double-quotes must be used inside single-quoted strings to get
+ this effect.
+ </para>
</listitem>
</varlistentry>
</variablelist>