Re: PostgreSQL Naming Rules

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Robert Buckley" <robertdbuckley(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Naming Rules
Date: 2011-10-28 14:08:04
Message-ID: D960CB61B694CF459DCFB4B0128514C2070C3F5E@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-28 14:21:50 Re: "Named" column default expression
Previous Message Alban Hertroys 2011-10-28 12:08:10 Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!