add enum type
Hi there supa wizards 🧙🏻 🧙🏾♂️ 🧙🏻♀️
How do u add a new enum type to an existing column?
3 Replies
If you google
postgres enum alter you should find some hits. It is not clear if you want to add to a set of enum values, or add/change a column to enum.thank u gary, I want to add to a set of enum values
https://www.postgresql.org/docs/current/sql-altertype.html docs on doing the sql to change it.
https://stackoverflow.com/questions/1771543/adding-a-new-value-to-an-existing-enum-type
PostgreSQL Documentation
ALTER TYPE
ALTER TYPE ALTER TYPE — change the definition of a type Synopsis ALTER TYPE name OWNER TO { new_owner | …
Stack Overflow
Adding a new value to an existing ENUM Type
I have a table column that uses an enum type. I wish to update that enum type to have an additional possible value. I don't want to delete any existing values, just add the new value. What is the