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: "'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 18:27:06
Message-ID: 51D7ECE75285D211810800600861E2D9325C5A@localhost (view raw or flat)
Thread:
Lists: pgsql-novice
> 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
> statements.
> 
> fbax=# create table test ("ID" int, ID int);
> CREATE
> 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

Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2002-01-31 20:15:37
Subject: Re: column headers all in upper-case letters?
Previous:From: Tom LaneDate: 2002-01-31 18:23:38
Subject: Re: problem query ...

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