SQL query column does not exist error

by

You’ve almost certainly added the column names in a case-sensitive environment. (PgAdmin comes to mind.) Lowercase them in that same environment to avoid the need to quote fields.

Or change your query to:

select * from places where "eventId" = 2

More Related Contents:

  1. When do Postgres column or table names need quotes and when don’t they?
  2. Strange behaviour in Postgresql
  3. What is PostgreSQL equivalent to autoincrement?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. INSERT with dynamic table name in trigger function
  6. psql: FATAL: Ident authentication failed for user “postgres”
  7. sql statement error: “column .. does not exist”
  8. Use multiple conflict_target in ON CONFLICT clause
  9. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  10. How to find table creation time?
  11. What is the format for the PostgreSQL connection string / URL?
  12. Go and IN clause in Postgres
  13. Where does PostgreSQL store the database?
  14. How to add “on delete cascade” constraints?
  15. Grant all on a specific schema in the db to a group role in PostgreSQL
  16. Can I make a plpgsql function return an integer without using a variable?
  17. Migrate database from Postgres to MySQL [closed]
  18. SQLAlchemy, Psycopg2 and Postgresql COPY
  19. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  20. Why can I create a table with PRIMARY KEY on a nullable column?
  21. Oracle SQL Developer and PostgreSQL
  22. Differentiate inserted and updated rows in UPSERT using system columns
  23. Can I use return value of INSERT…RETURNING in another INSERT?
  24. Changing a postgres containers server port in Docker Compose
  25. no pg_hba.conf entry for host
  26. PostgreSQL – disabling constraints
  27. PostgreSQL authentication method 10 not supported
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment