On 1/15/24 08:16, arun chirappurath wrote:
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.
Do you have psql(https://www.postgresql.org/docs/current/app-psql.html(
available?
If so in psql what does:
\d automobile
return?
Visually both statements are alike
Table is in public schema.
Thanks,
Arun
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
