seb=> \dv information_schema.*grant*
                          Список отношений
       Схема        |         Имя         |      Тип      | Владелец
--------------------+---------------------+---------------+----------
 information_schema | role_column_grants  | представление | postgres
 information_schema | role_routine_grants | представление | postgres
 information_schema | role_table_grants   | представление | postgres
 information_schema | role_usage_grants   | представление | postgres


select * from information_schema.role_table_grants;

psql -E -c '\z mytable_id_seq' -d mydb

********* QUERY **********
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 c.relname ~ '^(mytable_id_seq)$'
  AND n.nspname !~ '^pg_' AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY  1 ,  2 ;
**************************