WG: PostgreSQL Naming Rules

----- Weitergeleitete Message -----
Von: Robert Buckley <robertdbuckley(at)yahoo(dot)com>
An: Szymon Guz <mabewlun(at)gmail(dot)com>
Gesendet: 13:23 Freitag, 28.Oktober 2011
Betreff: Re: [GENERAL] PostgreSQL Naming Rules

Thanks,

I tried importing a table and I got some errors regarding Character sets. The error suggested I should use Latin1 instead of UTF8. I tried both, but I still keep getting the error. I looked at the field names and found german letters in the names hence the question here in the forum.

So in principle it is not a field name problem, and I have to look elsewhere.

thanks,

rob

________________________________
Von: Szymon Guz <mabewlun(at)gmail(dot)com>
An: Robert Buckley <robertdbuckley(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Gesendet: 13:15 Freitag, 28.Oktober 2011
Betreff: Re: [GENERAL] PostgreSQL Naming Rules

On 28 October 2011 12:49, Robert Buckley <robertdbuckley(at)yahoo(dot)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