WG: PostgreSQL Naming Rules

Поиск
Список
Период
Сортировка
От Robert Buckley
Тема WG: PostgreSQL Naming Rules
Дата
Msg-id 1319801034.61880.YahooMailNeo@web24102.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на PostgreSQL Naming Rules  (Robert Buckley <robertdbuckley@yahoo.com>)
Список pgsql-general
Дерево обсуждения

----- Weitergeleitete Message -----
Von: Robert Buckley <robertdbuckley@yahoo.com>
An: Szymon Guz <mabewlun@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 <mabewlun@gmail.com>
An: Robert Buckley <robertdbuckley@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 <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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: PostgreSQL Naming Rules
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!