Re: column headers all in upper-case letters?

From: Bob Savage <bobsavage(at)mac(dot)com>
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 16:40:08
Message-ID: B87ECF88.1AB69%bobsavage@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

on 1/31/02 8:32 AM, Sammer Reinhard J. wrote:

>> SELECT id AS "ID" FROM test
>>
>> but why??
>
> sorry, I was not precise.
>
> I am looking for a server or driver side configuration option
> as I don't want to rewrite all my SQL statements (>3500).
>
> I am porting an application running on MsSQL/Oracle DBs.
>

Hi, I am a novice as well, but it seems your problem might be better handled
at some point between the database and your SQL. What are you using to
connect the two? E.g. psql is an application that exists between the
database and your SQL statements; it might be the easiest place to force the
headers to appear as upper case.

best of luck,

Bob

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-01-31 17:02:21 Re: problem query ...
Previous Message John Taylor 2002-01-31 16:24:07 problem query ...