Generate proofs for EdgeDB¶

-- title: grantee
SELECT grantee
      ,table_catalog
      ,table_schema
      ,table_name
      ,string_agg(privilege_type, ', ' ORDER BY privilege_type) AS privileges
FROM information_schema.role_table_grants
WHERE grantee != 'postgres'
GROUP BY grantee, table_catalog, table_schema, table_name;

-- title: users
select *
from pg_user
order by usename;

-- title: group membership
select pg_group.groname, pg_group.grosysid, pg_user.*
from pg_group, pg_user
where pg_user.usesysid = any(pg_group.grolist)
order by usename,groname ;

-- title: privs
select *
from pg_namespace
order by nspname ;

-- title: owner
select *
from pg_tables
order by tablename ;