SQL WHERE - Column (value) does not exist [duplicate]

Question

I'm attempting to do the most basic WHERE statement in psql and I'm getting a strange error:

ERROR:  column "rom_tut" does not exist
LINE 1: SELECT * FROM pg_roles WHERE rolname="rom_tut";

Why is it complaining that the value isn't a column?

Answer 1

use single quote for string value because double quote means column name

SELECT * FROM pg_roles WHERE rolname='rom_tut'