Get enum type allowed values (Postgres)

enum-values.sql

SELECT
	n.nspname AS enum_schema,
	t.typname AS enum_name,
	e.enumlabel AS enum_value
FROM
	pg_type t
JOIN
	pg_enum e ON t.oid = e.enumtypid
JOIN
	pg_namespace n ON n.oid = t.typnamespace
WHERE
	t.typtype = 'e' -- Filters for ENUM types
	AND t.typname = 'XXXXX' -- replace here
ORDER BY
	enum_schema, enum_name, e.enumsortorder;