Re: PostgreSQL Naming Rules

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: PostgreSQL Naming Rules
Дата
Msg-id CAFjNrYs+M8N4QJvDuxLPZmgU8vrMVO1p7uOrhfz8reHeKCP-YQ@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL Naming Rules  (Robert Buckley <robertdbuckley@yahoo.com>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: Robert Buckley
Дата:
Сообщение: PostgreSQL Naming Rules
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: PostgreSQL Naming Rules