Columns names are case sensitive on postgres I have successfully migrated database from MySQL to PostgreSQL. While I am trying to connect with ofbiz, I am getting an error saying that 


  "user_id" not found. 


When I query against postgres by using

select * from user where user_id='1';


It's throwing the same error. But when I try with

select * from user where "USER_ID"='1';


It's fetching correctly. Table names are not case sensitive here, only column names. Can anyone give me a solution please?
When migrating, did the migration script double-quote the column names when creating tables? That would preserve the case.

You could either fix the migration script and re-import, or rename the columns e.g.

ALTER TABLE my_user RENAME COLUMN "USER_ID" TO user_id;


(note: user was used in the original question but that's a reserved keyword in Postgres so that couldn't have been one of the tables involved)