Re: disallowed characters in table names?

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