Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Alexander PucherDate: 2002-01-31 15:08:11
Subject: Query size of large object
Previous:From: Ewald GeschwindeDate: 2002-01-31 14:07:16
Subject: plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group