SQL query column does not exist error

I'm totally new in this area please tell me how to fix my problem.

when I write this query "SELECT * FROM places" in my database everything is okay. However when I change it to "SELECT * FROM places WHERE eventId=2", I get error. Please look at this image.

enter image description here

as you can see, eventId column is exist. Why my query throws error?

Solution

You've almost certainly added the column names in a case-sensitive environment. (PgAdmin comes to mind.) Lowercase them in that same environment to avoid the need to quote fields.

Or change your query to:

select * from places where "eventId" = 2