> 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