Sample Header Ad - 728x90

column "tum_first_name" of relation "tbl_users" does not exist, even when it does

0 votes
0 answers
2718 views
I have a tbl_users, where there are a few columns like TUM_First_Name,TUM_Last_Name and so on. However, when I try an insert query, an error says :- column "tum_first_name" of relation "tbl_users" does not exist Here is a photo of the schema :- enter image description here Update :- Surprisingly, after I renamed all the column names to lower cases, and called this same query, it worked. So, when my table had new column names as tum_first_name,tum_last_name, etc., running the query INSERT INTO tbl_users(TUM_First_Name,TUM_Last_Name,)... worked fine What is this ambiguity ?
Asked by Skumar (213 rep)
Jan 16, 2022, 02:45 PM
Last activity: Jan 16, 2022, 02:51 PM