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.