Postgresql "ERROR: column ... does not exist" In A Simple Query [duplicate]

Question

The query is:

select *
from "someTable"  
where "id" = "9gf1gf3123";

Postgresql gives me the error column does not exist while there wasn't a problem with my sql statement. The id exists, the table exists, I want to see everyting in my table, but does not work.
There are a lot of questions about this error but I wasn't able to find a solution.

Akhilesh Mishra · Accepted Answer · 2020-09-16 01:33:52Z

4

The problem was, I was writing string with ", not with '. When I changed the query like:

select *
from "userGroupUserOrganizations"  
where "id" = '9fce8e9b-597a-4100-bb3c-efb86aaa83ae';

it worked

edited Sep 16, 2020 at 1:33

Akhilesh Mishra

6,1503 gold badges20 silver badges37 bronze badges

answered Sep 16, 2020 at 0:19

Sahin

1,46318 silver badges28 bronze badges

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

1 Comment

user330315 Over a year ago

postgresql.org/docs/current/…

Collectives™ on Stack Overflow

Postgresql "ERROR: column ... does not exist" In A Simple Query [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related