column "tum_first_name" of relation "tbl_users" does not exist, even when it does
0
votes
0
answers
2718
views
I have a
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
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 :-

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
Last activity: Jan 16, 2022, 02:51 PM