Display postgres enum values

• To see all enums:

select n.nspname as enum_schema,  
    t.typname as enum_name,
    string_agg(e.enumlabel, ', ') as enum_value
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 enum_schema, enum_name;

thanks, StackOverflow

• To see one enum:

SELECT enumlabel  FROM pg_enum WHERE enumtypid = 'your_enum_here'::regtype;