Postgres Pro
Downloads
Home   >   mailing lists

Column names getting lower-case in SELECT statements when issued via JDBC - Mailing list pgsql-general

From Eduardas F.
Subject Column names getting lower-case in SELECT statements when issued via JDBC
Date
Msg-id BANLkTimgO_Be+WVW0qTnX8ZrGwbtvSXqhw@mail.gmail.com
Whole thread Raw
Responses Re: Column names getting lower-case in SELECT statements when issued via JDBC
Re: Column names getting lower-case in SELECT statements when issued via JDBC
List pgsql-general
Tree view
Hello everyone, today I encountered this nasty problem:
Whenever you issue an SELECT command from JDBC (prepared statement) you end up with column X does not exist. And column X name is shown in lower-case  As I understand, PostgreSQL Server or PostgreSQL JDBC driver converts column names containing upper-case letters to lower-case? Is there an easy way to bypass this behaviour? (Channing column names is not an option).


Here's an example of crashing SELECT: "SELECT password, accessLevel, lastServer, userIP FROM accounts WHERE login=?"
You end up with 'column "accesslevel" does not exist'.

Thanks for help in advance.

pgsql-general by date:

Previous
From: Tarlika Elisabeth Schmitz
Date:
Subject: Re: Role for CSV import
Next
From: Jerry Sievers
Date:
Subject: Re: Column names getting lower-case in SELECT statements when issued via JDBC