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?