Re: PostgreSQL Naming Rules - Mailing list pgsql-general

From Albe Laurenz
Subject Re: PostgreSQL Naming Rules
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2070C3F5E@exadv11.host.magwien.gv.at
Whole thread Raw
In response to PostgreSQL Naming Rules  (Robert Buckley <robertdbuckley@yahoo.com>)
List pgsql-general
Robert Buckley wrote:
> according to this article http://www.informit.com/articles/article.aspx?p=409471, the naming of
> tables, and fields is restricted to 63 characters and must start with an underscore or letter. Nothing
> is however said about in which character set.
>
> Am I allowed to name a table field < Änderung_1 >. The Ä is a german letter contained within the UTF8
> character set.

You can, but it's a really bad idea to have non-ASCII names.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Next
From: Tom Lane
Date:
Subject: Re: "Named" column default expression