Dear all, I have a table automobile which has a column id.
Table consists of id,make,year of manufacturing I use dbeaver for querying.. Select * from automobile provides me results However select id from automobile yields column doesn't exists. I tried double quotes on id As well but same error. But if I drag and drop id or use the id which is auto prompted from dbeaver,it works 💪. select "id" from automobile using drag and drop of id in dbeaver works. But if I manually type "id" it won't. Any clue on this. Visually both statements are alike Table is in public schema. Thanks, Arun