Getting an error on a Postgres table "ERROR: column does not exist" that doesn't make sense to me

378 views Asked by At

In pgAdmin if I do a simple select: "select * from NFT where item_id = 1271" I get what I would expect: enter image description here

However, when I try to query on this other column: "select * from NFT where tokenID = 40" I get an error: "ERROR: column "tokenid" does not exist

I'm new to Postgres in the last year, have used it quite a bit but this one has me stuck on how to proceed. It's just a normal column.

any ideas?

enter image description here

0

There are 0 answers