How to query PostgreSQL?

I’ve got a table as below, where SELECT * works, but if I change * to any specific column, I get the “pq: column does not exist error” (as shown in second image).

I’m quite new to this so any help would be greatly appreciated.


It seems on your screenshot that your column names contain upper case and Grafana try to use them with lower case. To keep upper case you need to write it between double quotes like that: Select "Overdue" FROM merged_df.