| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Naming Rules |
| Date: | 2011-10-28 11:19:09 |
| Message-ID: | j8e31u$1ho$1@dough.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Robert Buckley, 28.10.2011 12:49:
> 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.
It does work, but I have had some tools (JDBC based) that choked on those tables. And I had some troubles running pg_dump/pg_restore with those tables. But as I did that merely out of curiosity, I didn't bother to find a way on how to deal with them.
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Buckley | 2011-10-28 11:23:54 | WG: PostgreSQL Naming Rules |
| Previous Message | Szymon Guz | 2011-10-28 11:15:04 | Re: PostgreSQL Naming Rules |