Description
Working with a postgres database, Enum types are a frequently recurring topic, and are currently not supported as changes.
The postgres extension seems like the logical place to ask for this.
Implementation can be restricted to just Enum types, bringing parity with other databases that have support for enum type columns.
To eliminate tags in this area, support for 2 tags would be needed, and a third would be welcome but optional.
implementing creating of Postgres types, implementing https://www.postgresql.org/docs/current/sql-createtype.html
implementing the removal of Postgres types, implementing https://www.postgresql.org/docs/current/sql-droptype.html
implementing the modification of Postgres types, implementing https://www.postgresql.org/docs/current/sql-altertype.html