Showing enum types in PostreSQL

Just a quick tutorial for creating and displaying the existing ENUMs (Enumerated Data Types) in PostreSQL. Creating ENUMs in PostreSQL Creating an ENUM field in PostreSQL is very easy, we just need to use the CREATE TYPE statement: For example, if we need to create a table with a field “gender” which only accepts the values male and female, we …