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: (view raw, whole thread or download thread mbox)
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


>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,

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-2017 The PostgreSQL Global Development Group