Database browser empty in PostgreSQL

User, date Message
Written by cduprez
3 weeks ago
Category: General
6 posts since Fri, 22 Aug 14

On one of the PostgreSQL databases I am connecting to, the database browser is empty.
I have realized that this problem comes from the fact that the queries used to populate the database browser refer to "information_schema". But "information_schema" shows any schemas owned by roles you have the ability to SET
ROLE to. If you don't have enough privileges, the queries on these schemas are empty, and the browser to.

This privileges restriction does not exist when querying on pg_catalog.
Could you convert queries used in HeidiSQL using "information_schema" in order to query "pg_catalog" instead ?
Because this could result in having nothing showed by HeidiSQL in a database browser when a user has just read privileges.

Thanks in advance.
Cedric Duprez

Please login to leave a reply, or register at first.