Fetching all enum values from the database

[s0kil]

Is there a way for fetching all enums from the database for populating a selectField ?

[s0kil]

I have a ENUM defined as:

CREATE TYPE brokerage_subscription_type AS ENUM ('basic_subscription', 'bronze_subscription', 'silver_subscription', 'gold_subscription');

To get a list of all the ENUM values:

subscriptionTypes :: [BrokerageSubscriptionType] <- sqlQueryScalar "SELECT enum_range(NULL::brokerage_subscription_type)" ()

[mpscholten]

There's now a new allEnumValues function:

let subscriptionTypes = allEnumValues @ BrokerageSubscriptionType