| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | psimbo(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Description of disallowed characters in quoted identifiers is incomplete |
| Date: | 2025-07-22 09:02:24 |
| Message-ID: | c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-07-22 13:39:43 | Re: Description of disallowed characters in quoted identifiers is incomplete |
| Previous Message | Michael Paquier | 2025-07-22 05:10:32 | Re: Minor Improvements to pg_buffercache documentation |