Writing SQL Query statement to get a specific user from table

Question

I am using SQL query to get a specific user from the table, however, I am running into the issue where the postgresql is telling me that the column does not exist. It is a simple query statement that looks like this:

SELECT username FROM userlogins WHERE username = "test@email.com";

The ERROR:  column "test@email.com" does not exist

have you tried to visit any tutorial for postgresql fundamentals? — Ed Bangga, Sep 30 '19 at 01:58

score 0 · Answer 1 · answered Sep 30 '19 at 01:48

0

In SQL, you use single quotes to delimit strings. You use double quotes to escape identifiers. You simply want:

SELECT username
FROM userlogins
WHERE username = 'test@email.com';

Some databases allow the use of double quotes for strings, but that is generally just confusing -- and Postgres is not one of those databases.

answered Sep 30 '19 at 01:48

Gordon Linoff

1,242,037
58
646
786

Thank you! This whole time, single quote was not something I though about. Thank you! – Tim Tran Sep 30 '19 at 02:06

Writing SQL Query statement to get a specific user from table

1 Answers1