Search code examples
sqlpostgresqlstring-constant

delete "column does not exist"

I'm trying to execute a very simple delete query in Postgres

Query:

delete from "Tasks" where id = "fc1f56b5-ff41-43ed-b27c-39eac9354323";

Result:

ERROR:  column "fc1f56b5-ff41-43ed-b27c-39eac9354323" does not exist
LINE 1: delete from "Tasks" where id = "fc1f56b5-ff41-43ed-...

I have a simple table with a record where the id is that value. Why does it thing that "fc1f56b5-ff41-43ed-b27c-39eac9354323" is the column name?

Solution

  • The problem is that you are using double quotes (") and single quotes (') interchangeably. SQL treats what's inside double quotes "" as an identifier (i.e., table name, proc name, column name, etc.), character constants need to be enclosed in single quotes

    You can say:

    delete from "Tasks" where id = 'fc1f56b5-ff41-43ed-b27c-39eac9354323'