Query all enums in postgres

query.sql

SELECT (
    col.table_schema,
    col.table_name,
    col.ordinal_position as column_id,
    col.column_name,
    col.udt_name,
    string_agg(enu.enumlabel, ', ' ORDER BY enu.enumsortorder) AS enum_values
)
FROM information_schema.columns col
JOIN information_schema.tables tab ON tab.table_schema = col.table_schema
                                   AND tab.table_name = col.table_name
                                   AND tab.table_type = 'BASE TABLE'
JOIN pg_type typ ON col.udt_name = typ.typname
JOIN pg_enum enu ON typ.oid = enu.enumtypid
WHERE col.table_schema not in ('information_schema', 'pg_catalog')
      AND typ.typtype = 'e'
GROUP BY col.table_schema,
         col.table_name,
         col.ordinal_position,
         col.column_name,
         col.udt_name
ORDER BY col.table_schema,
         col.table_name,
         col.ordinal_position;