INSERT COMMAND :: ERROR: column “value” does not exist

by

Character constants need single quotes.

Use: INSERT INTO users(user_name, name, password,email) VALUES ('user2','first last','password1', '[email protected]' );

See the manual: postgresql.org/docs/current/static/…

Note: After I encountered the same problem and almost missed the answer that exists in this page (at the comments section), thanks to @a-horse-with-no-name – I’ve posted this answer

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. How to check if a table exists in a given schema
  3. How to implement a many-to-many relationship in PostgreSQL?
  4. How to speed up insertion performance in PostgreSQL
  5. Optimise PostgreSQL for fast testing
  6. Insert data in 3 tables at a time using Postgres
  7. Transpose latest rows per user to columns
  8. How to delete duplicate rows without unique identifier
  9. Best way to check for “empty or null value”
  10. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  11. PostgreSQL parameterized Order By / Limit in table function
  12. SQL Between clause with strings columns
  13. Insert an image in postgresql database
  14. NOT NULL constraint over a set of columns
  15. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  16. How do I alter the position of a column in a PostgreSQL database table?
  17. Query that ignore the spaces
  18. How to find a table having a specific column in postgresql
  19. Continuing a transaction after primary key violation error
  20. Use email address as primary key?
  21. Bulk/batch update/upsert in PostgreSQL
  22. SQL query to find record with ID not in another table
  23. How to show row numbers in PostgreSQL query?
  24. Postgres Error: More than one row returned by a subquery used as an expression
  25. Grant privileges for a particular database in PostgreSQL
  26. How to compare dates in datetime fields in Postgresql?
  27. PostgreSQL how to create a copy of a database or schema?
  28. Temporal database design, with a twist (live vs draft rows)
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment