Re: JDBC bug? - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: JDBC bug?
Date
Msg-id 1oh50u43l6cd9q714n4ndm63gm4n2080me@4ax.com
Whole thread Raw
In response to Re: JDBC bug?  ("Colin Freas" <cef6@georgetown.edu>)
List 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@lab.applinet.nl>

pgsql-jdbc by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: JDBC bug?
Next
From: Mike Cannon-Brookes
Date:
Subject: Re: [Fwd: Re: [Fwd: Re: Problems with truncated BLOB]]