From: | "Sammer Reinhard J(dot)" <RSammer(at)mlink(dot)co(dot)at> |
---|---|
To: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: column headers all in upper-case letters? |
Date: | 2002-01-31 18:27:06 |
Message-ID: | 51D7ECE75285D211810800600861E2D9325C5A@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> Sorry, I made a type in my previous example; so that it does not
> demonstrate my point properly/clearly. It's subtle, look for it the
> 'create' statement and last select example.
First, thank you.
>
> By default, Postgresql will convert all table and column
> names to lower
> case; both when you are creating the table and in sql
> statements that it
> processes. To override this, the table and column names must
> be enclosed
> in double quotes, both when the table is created and in all
> subsequent sql
> statements.
>
> fbax=# create table test ("ID" int, ID int);
> CREATE
> fbax=# insert into test values(1,2);
> INSERT 6096748 1
sorry for quoting myself:
> >I am looking for a server or driver side configuration option
> >as I don't want to rewrite all my SQL statements (>3500).
I'm using jdbc org.postgresql.Driver jdbc7.1-1.2.jar with a 7.1.3 DB
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2002-01-31 20:15:37 | Re: column headers all in upper-case letters? |
Previous Message | Tom Lane | 2002-01-31 18:23:38 | Re: problem query ... |