Error: Column does not exist in postgresql for update [duplicate]

by

In Postgres, double quote stand for identifiers (such as table or column names). Here, you actually want a string literal, so you need single quotes:

UPDATE public.meditech_ar_test4
SET filename="text"
WHERE filename is null;

Some databases (namely, MySQL), tolerate double quotes for string literals, while using other characters for identifiers (in MySQL: backticks). However in that regard Postgres follows the rules of standard SQL, which defines double quotes for identifiers. You should just take the habit of always using single quotes for string literals (most databases do support that).

More Related Contents:

  1. How to do an update + join in PostgreSQL?
  2. How to perform update operations on columns of type JSONB in Postgres 9.4
  3. How do I do large non-blocking updates in PostgreSQL?
  4. How does the search_path influence identifier resolution and the “current schema”
  5. How do you find the row count for all your tables in Postgres
  6. invalid byte sequence for encoding “UTF8”
  7. How do you use variables in a simple PostgreSQL script?
  8. How to make “case-insensitive” query in Postgresql?
  9. Rownum in postgresql
  10. How to switch databases in psql?
  11. Postgresql: Scripting psql execution with password
  12. dynamic sql query in postgres
  13. Cannot create a database table named ‘user’ in PostgreSQL
  14. Is there a timeout for idle PostgreSQL connections?
  15. How to make connection to Postgres via Node.js
  16. Postgresql Truncation speed
  17. Buffers (Circle) in PostGIS
  18. docker postgres pgadmin local connection
  19. Does a Postgres UNIQUE constraint imply an index?
  20. SELECT raises exception in PL/pgSQL function
  21. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  22. Changing primary key int type to serial
  23. Return SETOF rows from PostgreSQL function
  24. Dynamically generate columns for crosstab in PostgreSQL
  25. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  26. Postgresql insert trigger to set value
  27. Retrieving Comments from a PostgreSQL DB
  28. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  29. input file appears to be a text format dump. Please use psql
  30. Spring Docker container cannot access Postgres Docker container

Leave a Comment