Re: column headers all in upper-case letters? - Mailing list pgsql-novice

Okay, so how do triggers work then ?

I can write a daemon to accept messages from some ip (there already are 2
java daemons on arnold), add it to a transaction list a execute it asap.

What would the message look like ? a line of sql or what ?


On Thu, 31 Jan 2002, Frank Bax wrote:

> 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
> fbax=# select * from test;
>  ID | id
> ----+----
>   1 |  2
> (1 row)
>
> fbax=# select "ID" from test;
>  ID
> ----
>   1
> (1 row)
>
> fbax=# select id from test;
>  id
> ----
>   2
> (1 row)
>
> Frank
>
> At 03:32 PM 1/31/02 +0100, 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.
> >
> >>> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> --
> Virus scanned by edNET.
>

--
Chris Thompson
lightershade
t: +44 131 466 7003
d: +44 131 625 5603


--

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted.  Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of edNET or lightershade ltd. Finally, the
recipient should check this email and any attachments for the presence of
viruses.  edNET and lightershade ltd accepts no liability for any damage
caused by any virus transmitted by this email.

--

--
Virus scanned by edNET.