Postgres show user permissions on schema

How to list all privileges granted on a specific PostgreSQL database?

1.

Postgres grant select on all tables

Using sql:

It lists all the databases from the current connection along with their names, owners, character set encodings, and access privileges.

You can try this command to lists database roles.

You can also use to list tables, views and sequences with their associated access privileges.

2.

Using SQL Query:

Run this query:

For example:

Need a good GUI Tool for PostgreSQL?TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.

Download TablePlus free.