Postgresql Column Not Found, But Shows in Describe

by

Why do you use ` in column name?

You can use it without any quote characters, while with quote characters it may be case sensitive. Also such quote char is ", and not `

So use:

select "transactionAmount" 
from ... 
where ... 
group by "transactionAmount";

Read about identifiers at: http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html

More Related Contents:

  1. PostgreSQL “Column does not exist” but it actually does
  2. sql statement error: “column .. does not exist”
  3. Error: Column does not exist
  4. I keep getting the error “relation [TABLE] does not exist”
  5. PostgreSQL column ‘foo’ does not exist
  6. Select first row in each GROUP BY group?
  7. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  8. How to use RETURNING with ON CONFLICT in PostgreSQL?
  9. PostgreSQL DISTINCT ON with different ORDER BY
  10. Split comma separated column data into additional columns
  11. Escaping keyword-like column names in Postgres
  12. Transpose latest rows per user to columns
  13. Delete duplicate rows (don’t delete all duplicate)
  14. GROUP BY + CASE statement
  15. subquery in FROM must have an alias
  16. Compute percents from SUM() in the same SELECT sql query
  17. SQL Between clause with strings columns
  18. Insert an image in postgresql database
  19. Perform this hours of operation query in PostgreSQL
  20. Getting date list in a range in PostgreSQL
  21. Postgres Dynamic Query Function
  22. How do I delete a fixed number of rows with sorting in PostgreSQL?
  23. Does the JDBC spec prevent ‘?’ from being used as an operator (outside of quotes)?
  24. How to use an ALIAS in a PostgreSQL ORDER BY clause?
  25. INSERT COMMAND :: ERROR: column “value” does not exist
  26. Return multiple columns and rows from a function PostgreSQL instead of record
  27. Postgres error updating column data
  28. SQL LIKE condition to check for integer?
  29. Counting the number of occurrences of a substring within a string in PostgreSQL
  30. Is there a postgres CLOSEST operator?

Leave a Comment