\dp [ PATTERN ]
The \dp [ PATTERN ]
meta-command returns the grantee, grantor, privileges, schema, and name for all table access privileges in each schema:
vmartdb=> \dp
Access privileges for database "vmartdb"
Grantee | Grantor | Privileges | Schema | Name
---------+---------+------------+--------+------------
| dbadmin | USAGE | | public
| dbadmin | USAGE | | v_internal
| dbadmin | USAGE | | v_catalog
| dbadmin | USAGE | | v_monitor
(4 rows)
Note: \dp is the same as \z.