postgres column “X” does not exist

by

Use single quotes for string constants

INSERT INTO config_change_log(last_config_version, is_done, change_description )
VALUES('5837-2016-08-24_09-12-22', false, '{ ''key'':''value''}');

Also you can escape single quotes in data by doubling them

More Related Contents:

  1. Insert text with single quotes in PostgreSQL
  2. Are PostgreSQL column names case-sensitive?
  3. How to check if a table exists in a given schema
  4. How to declare a variable in a PostgreSQL query
  5. Save PL/pgSQL output from PostgreSQL to a CSV file
  6. Difference between language sql and language plpgsql in PostgreSQL functions
  7. Query with LEFT JOIN not returning rows for count of 0
  8. How do I force Postgres to use a particular index?
  9. How can I send email from PostgreSQL trigger?
  10. Find overlapping date ranges in PostgreSQL
  11. How do you do date math that ignores the year?
  12. Postgres manually alter sequence
  13. What’s the proper index for querying structures in arrays in Postgres jsonb?
  14. “Operator does not exist: integer =?” when using Postgres
  15. Oracle equivalent of Postgres’ DISTINCT ON?
  16. Postgres sql insert query syntax error from phpPgAdmin
  17. postgresql generate sequence with no gap
  18. PostgreSQL: Case insensitive string comparison
  19. Combine two columns and add into one new column
  20. Bulk/batch update/upsert in PostgreSQL
  21. Grant privileges for a particular database in PostgreSQL
  22. Timestamp Difference In Hours for PostgreSQL
  23. SQL INSERT without specifying columns. What happens?
  24. Operator does not exist: json = json
  25. Function with SQL query has no destination for result data
  26. Postgres INTERVAL using value from table
  27. Crosstab with a large or undefined number of categories
  28. Conditional lead/lag function PostgreSQL?
  29. Postgres and Indexes on Foreign Keys and Primary Keys
  30. Select random row from a PostgreSQL table with weighted row probabilities

Leave a Comment