Re: disallowed characters in table names? - Mailing list pgsql-novice

From Tom Lane
Subject Re: disallowed characters in table names?
Date
Msg-id 20764.1181527200@sss.pgh.pa.us
Whole thread Raw
In response to disallowed characters in table names?  (Steve Lefevre <lefevre.10@osu.edu>)
Responses Formatting function, simple Q  (nhrcommu@rochester.rr.com)
List pgsql-novice
Steve Lefevre <lefevre.10@osu.edu> writes:
> Can someone point me to a resource where I can find the disallowed
> characters in Postgres database, table, and field names?

http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

For an unquoted name, it's basically a-z, underscore, plus any and
all non-ASCII characters, plus digits and $ after the first character.
The nitty-gritty is the flex definition:

ident_start        [A-Za-z\200-\377_]
ident_cont        [A-Za-z\200-\377_0-9\$]
identifier        {ident_start}{ident_cont}*

Quoted names allow anything at all except \0.

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: disallowed characters in table names?
Next
From: "David Monarchi"
Date:
Subject: query plan and the use of indexes