| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-11-26 23:36:49 | Re: insert/update/delete statements returning a query response |
| Previous Message | Ross J. Reedstrom | 2001-11-26 21:58:31 | Re: JDBC bug? |