Hi Adrian, \d shows the tables and this id which is a sequence.
Regards, Arun On Mon, 15 Jan 2024 at 22:03, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > 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.kla...@aklaver.com > >
