a problem with case in psql - Mailing list pgsql-bugs

From Øystein Thorsen
Subject a problem with case in psql
Date
Msg-id 000a01c1db4f$cfd77db0$0a01a8c0@valby5dt2v28f2
Whole thread Raw
Responses Re: a problem with case in psql  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
I've used pgAccess to make all the tables and colums.
Ex.: table diagnosis column diagnosis_ID

Then, when I use psql to execute select statements, diagnosis_ID does
not exist.

But when I change the column name to diagnosis_id it works fine.

The problem is therefore that it is possible to create a column name
with uppercase but psql transforms all statements to lowercase, and
therefore will not work.

(Sorry about my bad English)

Øystein Thorsen
Norwegian student

pgsql-bugs by date:

Previous
From: "Pierre-Alexis Paquin"
Date:
Subject: Bugs report
Next
From: Stephan Szabo
Date:
Subject: Re: a problem with case in psql