Message-ID: <c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel@cybertec.at>
Subject: Re: Description of disallowed characters in quoted identifiers is
 incomplete
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: psimbo@gmail.com, pgsql-docs@lists.postgresql.org
Date: Tue, 22 Jul 2025 11:02:24 +0200
In-Reply-To: <175312790281.787.11714206460573047530@wrigleys.postgresql.org>
References: <175312790281.787.11714206460573047530@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-07-21 at 19:58 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/17/sql-syntax-lexical.html
> Description:
>=20
> Section 4.1.1 of the documentation claims that "Quoted identifiers can
> contain any character, except the character with code zero." However
> according to line 105 in src/test/isolation/specscanner.l in the PostgreS=
QL
> source code, new line characters are also disallowed.

psql (18beta2)
Type "help" for help.

test=3D> CREATE TABLE "new
       line" ();
CREATE TABLE
test=3D> \dt new*
           List of tables
 Schema  =E2=94=82  Name  =E2=94=82 Type  =E2=94=82  Owner =20
=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=
=95=90=E2=95=AA=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=
=90=E2=95=90=E2=95=AA=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=
=E2=95=90=E2=95=AA=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=
=95=90=E2=95=90=E2=95=90
 laurenz =E2=94=82 new   =E2=86=B5=E2=94=82 table =E2=94=82 laurenz
         =E2=94=82 line   =E2=94=82       =E2=94=82=20
 laurenz =E2=94=82 newtab =E2=94=82 table =E2=94=82 laurenz
(2 rows)

Yours,
Laurenz Albe