Re: column headers all in upper-case letters?

From: "Sammer Reinhard J(dot)" <RSammer(at)mlink(dot)co(dot)at>
To: "'Rasmus Mohr'" <rmo(at)Netpointers(dot)com>
Cc: "'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 14:32:09
Message-ID: 51D7ECE75285D211810800600861E2D9325C57@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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.

>> Could you please point me to the fine document where I can
>> information
>> regarding:
>>
>> Is there a way to force PostgreSQL or the jdbc Driver to
>> return column
>> headers all in upper-case letters?
>>
>> e.g. table test with column ID type int:
>> I want that a 'select * from test;' returns 'ID' not 'id' as
>> column header.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Pucher 2002-01-31 15:08:11 Query size of large object
Previous Message Ewald Geschwinde 2002-01-31 14:07:16 plpgsql