Re: Description of disallowed characters in quoted identifiers is incomplete

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Description of disallowed characters in quoted identifiers is incomplete
Дата
Msg-id c4fd3cdde64ad7f8e007fbf7a888a11e1cd42b2a.camel@cybertec.at
обсуждение исходный текст
Ответ на Description of disallowed characters in quoted identifiers is incomplete  (PG Doc comments form <noreply@postgresql.org>)
Список 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



В списке pgsql-docs по дате отправления: