----- Weitergeleitete Message -----
Von: Robert Buckley <robertdbuck...@yahoo.com>
An: Szymon Guz <mabew...@gmail.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 <mabew...@gmail.com>
An: Robert Buckley <robertdbuck...@yahoo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Gesendet: 13:15 Freitag, 28.Oktober 2011
Betreff: Re: [GENERAL] PostgreSQL Naming Rules
On 28 October 2011 12:49, Robert Buckley <robertdbuck...@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
