Finding specific row in postgres

Question

The following SQL:

SELECT * FROM extensiondata WHERE name="Post To Tumblr";

Generates this error:

ERROR:  column "Post To Tumblr" does not exist

I have a column called name. As far as I know where name="search" should find a row where the column name is equal to search. So what is amiss?

Clodoaldo Neto · Accepted Answer · 2014-06-06 17:36:05Z

1

name = 'Post To Tumblr'

Use single quotes for values. Double quotes are used for identifiers.

answered Jun 6, 2014 at 17:36

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1