PG list enums

pg_enums.sql

select n.nspname as enum_schema,  
       t.typname as enum_name,  
       string_agg(e.enumlabel, ', ') as enum_values
from pg_type t 
   join pg_enum e on t.oid = e.enumtypid  
   join pg_catalog.pg_namespace n ON n.oid = t.typnamespace
group by n.nspname, t.typname
order by enum_name;