> 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
> fbax=# create table test ("ID" int, ID int);
> 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
pgsql-novice by date
|Next:||From: Frank Bax||Date: 2002-01-31 20:15:37|
|Subject: Re: column headers all in upper-case letters?|
|Previous:||From: Tom Lane||Date: 2002-01-31 18:23:38|
|Subject: Re: problem query ... |