I am using Grafana for visualisation for my Mariadb and Postgres databases. On Mariadb, there are suggestions in the query builder for the column row but not on Postgres. If I type the name myself, it shows the data correctly but no suggestion is shown. Can anyone help?

CodePudding user response：

You don't have any suitable column (numeric type, e.g. int, float, ...) in zf1_table table, so that's a reason why editor is not offering any column in the select section.

Or very likely you don't have proper permissions: https://grafana.com/docs/grafana/latest/datasources/postgres/#database-user-permissions-important

So used Grafana DB user can't read table structure.