PostgreSQL - WHERE clause not working - Column name not found [duplicate]

Question

My simple WHERE query is not working. It says column "Exception" does not exist, but the column it type, that is only a value.

SQL Query:

select * from logs
where type = "Exception"

Answer 1

As S-Man commented the answer is: " characters are for column names. You have to use ' characters.

Answer 2

Try this one:

SELECT *
FROM
   logs
WHERE
   type = 'Exception'