postgres – where in (list) – column does not exist

by

Use single quotes for string constants:

DELETE FROM user_job_titles
    WHERE id IN ('c836d018-1d12-4507-a268-a4d80d6d3f54',
                 'd0961a90-7d31-4c4c-9c1b-671115e3d833',
                 '62dda420-6e62-4017-b41d-205c0aa82ead'
                );

Double quotes are an escape character used with table and column names. Hence the error.

More Related Contents:

  1. delete “column does not exist”
  2. Column ‘mary’ does not exist
  3. How to return result of a SELECT inside a function in PostgreSQL?
  4. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  5. Possible to perform cross-database queries with PostgreSQL?
  6. Reset auto increment counter in postgres
  7. Optimize query with OFFSET on large table
  8. GROUP BY and aggregate sequential numeric values
  9. Safely rename tables using serial primary key columns
  10. How to concatenate columns in a Postgres SELECT?
  11. How to use (install) dblink in PostgreSQL?
  12. get JOIN table as array of results with PostgreSQL/NodeJS
  13. How can I send email from PostgreSQL trigger?
  14. PostgreSQL multi INSERT…RETURNING with multiple columns
  15. Postgres manually alter sequence
  16. What’s the proper index for querying structures in arrays in Postgres jsonb?
  17. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  18. Oracle equivalent of Postgres’ DISTINCT ON?
  19. Postgres sql insert query syntax error from phpPgAdmin
  20. postgresql generate sequence with no gap
  21. Combine two columns and add into one new column
  22. Bulk/batch update/upsert in PostgreSQL
  23. Postgres Error: More than one row returned by a subquery used as an expression
  24. Update a column of a table with a column of another table in PostgreSQL
  25. Check if NULL exists in Postgres array
  26. How to detect query which holds the lock in Postgres?
  27. PostgreSQL how to create a copy of a database or schema?
  28. PostgreSQL: fill NULL values in timeserie query with previous value
  29. Get most common value for each value of another column in SQL
  30. PostgreSQL: top n entries per item in same table

Leave a Comment