postgresql: Get all values for an enum

SELECT enum_range(NULL::portal) # Returns an array of all possible values
SELECT unnest(enum_range(NULL::portal)) # Unnests the array and returns a row for each value

Whereas portal is the enum type.