I am new to work with PostgreSQL. I faced the problem while executes the query (column not found) when I migrate the database from MySql to PostgreSQL.
ie, in MySQL I have on the table name provider in that one column name is authType. At the time of migration of database this column was created like "AuthType"(with quotes) in my PostgreSQL because of mixed case letters. When i run the select query like "select authType from provider" it is working fine in MySQL, but it is not working on PostgreSQL.
How to avoid the quotes to the column before execute the query. I have 100 more tables and each table has some columns with mixed case letters.