| From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
|---|---|
| To: | Robert Buckley <robertdbuckley(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Naming Rules |
| Date: | 2011-10-28 11:15:04 |
| Message-ID: | CAFjNrYs+M8N4QJvDuxLPZmgU8vrMVO1p7uOrhfz8reHeKCP-YQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2011-10-28 11:19:09 | Re: PostgreSQL Naming Rules |
| Previous Message | whiplash | 2011-10-28 11:15:02 | Client-site "lo_export" |