Unable to fetch results from postgres

Question

Postgres not able to get results queried

opinion_db=# select * from verification_codes;
      user       | code  | id |          created_at           |          updated_at           | deleted_at 
-----------------+-------+----+-------------------------------+-------------------------------+------------
 [email protected] | 12345 |  1 | 2019-09-26 17:40:25.055544+00 | 2019-09-26 17:40:25.063162+00 | 
 [email protected] | 12345 |  2 | 2019-09-26 17:40:25.055544+00 | 2019-09-26 17:40:25.063162+00 | 
(2 rows)

opinion_db=# select * from verification_codes where user = '[email protected]';
 user | code | id | created_at | updated_at | deleted_at 
------+------+----+------------+------------+------------
(0 rows)

opinion_db=#

The bytes stored are

opinion_db=# SELECT "user"::bytea FROM verification_codes;
                 user
----------------------------------
\x656464696540676d61696c2e636f6d
\x656464696540676d61696c2e636f6d

What is happening here??

What do you get for SELECT "user"::bytea FROM verification_codes;? — Laurenz Albe
– Laurenz Albe, Commented Sep 26, 2019 at 17:59

jjanes · Accepted Answer · 2019-09-26 18:06:34Z

3

user refers to the database user. You need "user" to refer to a column named "user".

You should not use database reserved words as column names, it is confusing, like here.

answered Sep 26, 2019 at 18:06

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Unable to fetch results from postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related