Re: Problem : Sql queries are created in lowercase - Mailing list pgsql-jdbc

From Euler Taveira de Oliveira
Subject Re: Problem : Sql queries are created in lowercase
Date
Msg-id 20061001211549.GA18409@timbira.com
Whole thread Raw
In response to Problem : Sql queries are created in lowercase  ("Josep" <josepk@gmail.com>)
List 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/


pgsql-jdbc by date:

Previous
From: "Josep"
Date:
Subject: Problem : Sql queries are created in lowercase
Next
From: Oliver Jowett
Date:
Subject: Re: Bug extracting money value