Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group