delete “column does not exist”

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'

Leave a Comment

tech