delete “column does not exist”

by

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'

More Related Contents:

  1. Column ‘mary’ does not exist
  2. postgres – where in (list) – column does not exist
  3. Aggregate columns with additional (distinct) filters
  4. Computed / calculated / virtual / derived columns in PostgreSQL
  5. Insert data in 3 tables at a time using Postgres
  6. How to use ANY instead of IN in a WHERE clause?
  7. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  8. sql ORDER BY multiple values in specific order?
  9. Is there a way to define a named constant in a PostgreSQL query?
  10. Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
  11. Postgres unique constraint vs index
  12. How to select id with max date group by category in PostgreSQL?
  13. Permanently Set Postgresql Schema Path
  14. PostgreSQL ORDER BY issue – natural sort
  15. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  16. Slow simple update query on PostgreSQL database with 3 million rows
  17. How do I alter the position of a column in a PostgreSQL database table?
  18. Return setof record (virtual table) from function
  19. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  20. Alphanumeric sorting with PostgreSQL
  21. Transposing an sql result so that one column goes onto multiple columns
  22. How to use multiple CTEs in a single SQL query?
  23. How to convert PostgreSQL 9.4’s jsonb type to float
  24. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  25. How to get a list column names and datatypes of a table in PostgreSQL?
  26. Referencing current row in FILTER clause of window function
  27. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  28. Insert data and set foreign keys with Postgres
  29. Fetch records that are non zero after the decimal point in PostgreSQL
  30. How to use a ring data structure in window functions

Leave a Comment