PostgreSQL logoI've been working recently with PostgreSQL (see Queries on error with PostgreSQL in Talend Open Studio) and I've discovered the way PostgreSQL handles case sensitivity.

Column, table and schema names are case sensitive, ie you can have a column Id and ID in the same table. Not very usual (you can't do this in MySQL or Oracle). The problem is that PostgreSQL automaticaly lowercase schema/table/column names in the queries! Very funny, isn't it?

Lire la suite