list-all-values-for-custom-enum-postgres.md

List all values of a custom enum in Postgres

Posted on 23 May, 2023

select enum_range(null::my_enum)

To list in separate rows

select unnest(enum_range(null, null::my_enum));