From: Laurenz Albe <laurenz.albe@cybertec.at>
To: psimbo@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: Description of disallowed characters in quoted identifiers is incomplete
Date: Tue, 22 Jul 2025 11:02:24 +0200
Message-ID: <c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel@cybertec.at> (raw)
In-Reply-To: <175312790281.787.11714206460573047530@wrigleys.postgresql.org>
References: <175312790281.787.11714206460573047530@wrigleys.postgresql.org>
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:
>
> 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 PostgreSQL
> source code, new line characters are also disallowed.
psql (18beta2)
Type "help" for help.
test=> CREATE TABLE "new
line" ();
CREATE TABLE
test=> \dt new*
List of tables
Schema │ Name │ Type │ Owner
═════════╪════════╪═══════╪═════════
laurenz │ new ↵│ table │ laurenz
│ line │ │
laurenz │ newtab │ table │ laurenz
(2 rows)
Yours,
Laurenz Albe
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: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, psimbo@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Description of disallowed characters in quoted identifiers is incomplete
In-Reply-To: <c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox