Is there a way to show a user-defined postgresql enumerated type definition? January 9, 2023 by Tarik Check this: select enum_range(null::my_type) I think this is a much simpler solution :).