Обсуждение: Problem : Sql queries are created in lowercase

Hi friends,
I am using postgresql 81 and I have seen that when you launch an sql
sentence with psql admin III of create for example :

CREATE TABLE CONTACT
(
  id int8 NOT NULL,
  firstname varchar(255),
  lastname varchar(255),
  email varchar(255),
  CONSTRAINT contact_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE CONTACT OWNER TO prova;

Then this table is created but in lowercase :-( , if you create the
table manually then is created how you put( lowerCase or UpperCase).

When using JDBC its happend the same, if I created a table from jdbc
with uppercase then is created in lowercase and this is a problem
becouse if you launch a select searching "contact" is not the same that
searching "CONTACT" and all goes bad :-(.

I have tryed with all drivers of jdbdc of postresql and the same
happens.

Some Idea?

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/