PostgreSQL lower case or remove double quotes on every table name before select query
0
votes
0
answers
739
views
We are migrating from OracleDB to PostgreSQL and all the tables name in database are lower case while the script from application is mixed with double quotes.
For example the code in application like this:
SELECT * FROM "USER_ID";
Can it be change to:
SELECT * FROM "user_id";
or
SELECT * FROM USER_ID;
Is there anyway to lower case or remove double quotes for every tables name on query?
Asked by Entaah Laah
(1 rep)
Jan 14, 2023, 04:23 AM
Last activity: Jan 14, 2023, 08:43 AM
Last activity: Jan 14, 2023, 08:43 AM