WG: PostgreSQL Naming Rules

[Robert Buckley <robertdbuckley@xxxxxxxxx>]

----- Weitergeleitete Message -----
Von: Robert Buckley <robertdbuckley@xxxxxxxxx>
An: Szymon Guz <mabewlun@xxxxxxxxx>
Gesendet: 13:23 Freitag, 28.Oktober 2011
Betreff: Re: 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@xxxxxxxxx>
An: Robert Buckley <robertdbuckley@xxxxxxxxx>
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Gesendet: 13:15 Freitag, 28.Oktober 2011
Betreff: Re: [GENERAL] PostgreSQL Naming Rules

On 28 October 2011 12:49, Robert Buckley <robertdbuckley@xxxxxxxxx> 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