Postgres error updating column data

by

There is no need to wrap table name in double quote "employee", and use single quotes for column values

UPDATE employee   
   SET first_name="ok", last_name="pk", email="ooo", phone="000"
 WHERE employee_id = 1;

See Working Example

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. updating table rows in postgres using subquery
  3. Return pre-UPDATE column values using SQL only
  4. Casting NULL type when updating multiple rows
  5. Slow simple update query on PostgreSQL database with 3 million rows
  6. SQL update fields of one table from fields of another one
  7. Bulk/batch update/upsert in PostgreSQL
  8. Update a column of a table with a column of another table in PostgreSQL
  9. Functions with variable number of input parameters
  10. Aggregate columns with additional (distinct) filters
  11. Computed / calculated / virtual / derived columns in PostgreSQL
  12. Insert data in 3 tables at a time using Postgres
  13. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  14. sql ORDER BY multiple values in specific order?
  15. PostgreSQL: Which Datatype should be used for Currency?
  16. PostgreSQL sequence based on another column
  17. Finding similar strings with PostgreSQL quickly
  18. NOT NULL constraint over a set of columns
  19. Sort NULL values to the end of a table
  20. Window Functions or Common Table Expressions: count previous rows within range
  21. postgresql – sql – count of `true` values
  22. Select (retrieve) all records from multiple schemas using Postgres
  23. Optimize groupwise maximum query
  24. Use email address as primary key?
  25. Creating temporary tables in SQL
  26. PostgreSQL where all in array
  27. incomplete information from query on pg_views [duplicate]
  28. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  29. How to get a list column names and datatypes of a table in PostgreSQL?
  30. Referencing current row in FILTER clause of window function

Leave a Comment