public inbox for [email protected]
help / color / mirror / Atom feedFrom: Álvaro Rodríguez <[email protected]>
To: [email protected]
Subject: Update documentation for SET to include SCHEMA / NAMES syntax
Date: Fri, 27 Mar 2026 17:23:43 +0100
Message-ID: <CA+C_kKVH5gRJg4a+pQjX4LDwvWzWwoDWBV8-_E-wXnZdFKrRXA@mail.gmail.com> (raw)
Hi,
The attached patch updates the documentation for the SET statement to
include the special syntax for SCHEMA / NAMES in the synopsis. The
current documentation only mentions this special syntax under the
parameters, which is confusing and different from the usual practice.
We could consider also moving the description on the special syntax up
to the description instead of keeping it under parameters, but the
TIME ZONE variant is already explained under the parameters too so I
thought better to keep the current structure.
Thanks,
Álvaro Rodríguez
Attachments:
[application/octet-stream] v1-0001-Update-the-SET-statement-documentation-for-clarit.patch (1.1K, 2-v1-0001-Update-the-SET-statement-documentation-for-clarit.patch)
download | inline diff:
From 5b671e54da53f3677ee07cf9769196ae4efab240 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?=C3=81lvaro=20Rodr=C3=ADguez?=
<[email protected]>
Date: Thu, 26 Mar 2026 17:56:17 +0100
Subject: [PATCH v1 1/1] Update the SET statement documentation for clarity
when using SCHEMA and NAMES
Added a new variant to the SET statement to include the special syntax for SET SCHEMA and SET NAMES.
---
doc/src/sgml/ref/set.sgml | 1 +
1 file changed, 1 insertion(+)
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index 16c7e9a7b26..63843a6b85c 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -22,6 +22,7 @@ PostgreSQL documentation
<refsynopsisdiv>
<synopsis>
SET [ SESSION | LOCAL ] <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> [, ...] | DEFAULT }
+SET [ SESSION | LOCAL ] [ SCHEMA | NAMES ] { '<replaceable class="parameter">value</replaceable>' }
SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replaceable> | LOCAL | DEFAULT }
</synopsis>
</refsynopsisdiv>
--
2.52.0
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Update documentation for SET to include SCHEMA / NAMES syntax
In-Reply-To: <CA+C_kKVH5gRJg4a+pQjX4LDwvWzWwoDWBV8-_E-wXnZdFKrRXA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox