PostgreSQL – How to filter on a column with uppercase letters in its name
On PostgreSQL, a column whose name contains an uppercase letter must be wrapped in double quotes to be read or modified. Syntax and best practice to avoid this common pitfall.