Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Naming Rules - Mailing list pgsql-general

From Szymon Guz
Subject Re: PostgreSQL Naming Rules
Date
Msg-id CAFjNrYs+M8N4QJvDuxLPZmgU8vrMVO1p7uOrhfz8reHeKCP-YQ@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Naming Rules  (Robert Buckley <robertdbuckley@yahoo.com>)
List pgsql-general
Tree view


On 28 October 2011 12:49, Robert Buckley <robertdbuckley@yahoo.com> wrote:


Hi,

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.

yours,


Rob


The simplest answer is: just check it.

however this works for me:

create table "Änderung_1" (i integer);
select * from "Änderung_1";


regards
Szymon

pgsql-general by date:

Previous
From: Robert Buckley
Date:
Subject: PostgreSQL Naming Rules
Next
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL Naming Rules