Re: Problem : Sql queries are created in lowercase

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Josep <josepk(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem : Sql queries are created in lowercase
Date: 2006-10-01 21:15:49
Message-ID: 20061001211549.GA18409@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Josep wrote:

> Then this table is created but in lowercase :-( , if you create the
> table manually then is created how you put( lowerCase or UpperCase).
>
No. See the documentation [1]. "Identifier and key word names are case
insensitive." So all names are lower case before created unless you
quote them. This is per SQL standard.

[1]
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-10-01 21:25:29 Re: Bug extracting bit value
Previous Message Oliver Jowett 2006-10-01 21:11:33 Re: Bug extracting money value