Старый вопрос.
psql -E - лучший пример 8) Вот запрос который дает список обектов и права пользователей.
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'S' THEN 'sequence' END as "Type",
c.relacl as "Access privileges"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r', 'v', 'S')
AND n.nspname !~ '^pg_' AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1, 2;

psql test
Welcome to psql 8.1.0, the PostgreSQL interactive terminal.
test=# \df *acl*
List of functions
Schema | Name | Result data type | Argument data types
------------+--------------+------------------+-------------------------
pg_catalog | aclcontains | boolean | aclitem[], aclitem
pg_catalog | aclinsert | aclitem[] | aclitem[], aclitem
pg_catalog | aclitemeq | boolean | aclitem, aclitem
pg_catalog | aclremove | aclitem[] | aclitem[], aclitem
pg_catalog | hash_aclitem | integer | aclitem
pg_catalog | makeaclitem | aclitem | oid, oid, text, boolean
(6 rows)

test=#

Остальное - RTFM!