Re: [GENERAL] PostgreSQL Naming Rules - another question

2011-10-30 Thread Sim Zacks
On 10/29/2011 12:53 PM, Szymon Guz wrote: Hi, according to this part of documentation: http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL- SYNTAX-IDENTIFIERS if I select some names from database and

[GENERAL] PostgreSQL Naming Rules - another question

2011-10-29 Thread Szymon Guz
Hi, according to this part of documentation: http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL- SYNTAX-IDENTIFIERS if I select some names from database and sort them... which collation is used? regards Szymon

[GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Robert Buckley
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

Re: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Szymon Guz
On 28 October 2011 12:49, Robert Buckley robertdbuck...@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

Re: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Thomas Kellerer
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

WG: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Robert Buckley
- Weitergeleitete Message - Von: Robert Buckley robertdbuck...@yahoo.com An: Szymon Guz mabew...@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

Re: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Albe Laurenz
Robert Buckley wrote: 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

Re: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Adrian Klaver
On Friday, October 28, 2011 3:49:58 am Robert Buckley 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

Re: [GENERAL] PostgreSQL Naming Rules

2011-10-28 Thread Craig Ringer
On 10/28/2011 06:49 PM, Robert Buckley wrote: 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