Блин.... . Вот что делает psql по команде \z
SELECT n.nspname as "Схема",
c.relname as "Таблица",
c.relacl as "Привилегии доступа"
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 pg_catalog.pg_table_is_visible(c.oid) AND n.nspname !~ '^pg_'
ORDER BY 1, 2;