Skip site navigation (1) Skip section navigation (2)

Re: JDBC bug?

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: "Colin Freas" <cef6(at)georgetown(dot)edu>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC bug?
Date: 2001-11-26 22:54:04
Message-ID: 1oh50u43l6cd9q714n4ndm63gm4n2080me@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Mon, 26 Nov 2001 16:24:46 -0500, you wrote:
>I just think mixed case identifiers are easier on the eyes.

That's fine. Since SQL is case insensitive you can write the
names anyway you like.

>Postgres stores the identifiers in a case insensitve manner by default

Yes.

>but if you mix case when creating the tables or what have you, it stores 
>them as case sensitive.  

No, only when you quote the names when creating the tables. Its
up to you. If you don't quote them your problems are gone,
IIUYC.

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

In response to

pgsql-jdbc by date

Next:From: Tom LaneDate: 2001-11-26 23:36:49
Subject: Re: insert/update/delete statements returning a query response
Previous:From: Ross J. ReedstromDate: 2001-11-26 21:58:31
Subject: Re: JDBC bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group