You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: doc/src/sgml/ref/alter_system.sgml
+9-1Lines changed: 9 additions & 1 deletion
Original file line number
Diff line number
Diff line change
@@ -21,7 +21,7 @@ PostgreSQL documentation
21
21
22
22
<refsynopsisdiv>
23
23
<synopsis>
24
-
ALTER SYSTEM SET <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable>| '<replaceable class="parameter">value</replaceable>' | DEFAULT }
24
+
ALTER SYSTEM SET <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable>[, ...] | DEFAULT }
25
25
26
26
ALTER SYSTEM RESET <replaceable class="parameter">configuration_parameter</replaceable>
27
27
ALTER SYSTEM RESET ALL
@@ -82,9 +82,17 @@ ALTER SYSTEM RESET ALL
82
82
New value of the parameter. Values can be specified as string
83
83
constants, identifiers, numbers, or comma-separated lists of
84
84
these, as appropriate for the particular parameter.
85
+
Values that are neither numbers nor valid identifiers must be quoted.
85
86
<literal>DEFAULT</literal> can be written to specify removing the
86
87
parameter and its value from <filename>postgresql.auto.conf</filename>.
87
88
</para>
89
+
90
+
<para>
91
+
For some list-accepting parameters, quoted values will produce
92
+
double-quoted output to preserve whitespace and commas; for others,
93
+
double-quotes must be used inside single-quoted strings to get