SQL WHERE - Column (value) does not exist

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?

https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS — , Oct 25 '18 at 11:35

score 12 · Accepted Answer · answered Oct 25 '18 at 11:33

12

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

SELECT * FROM pg_roles WHERE rolname='rom_tut'

answered Oct 25 '18 at 11:33

3

I can't believe I've used SQL for this long and never knew that! Thanks – Danny Santos Oct 25 '18 at 12:14

1 Answers1