- Published on
How to Add Value to Existing Enum in Postgres
- Authors
- Name
- TekLoon
Problem
We have an existing enum in Postgres and we want to add a new value to it. The existing enum looks like this:
CREATE TYPE gift_card_status_enum AS ENUM ('locked', 'unlocked');
The enum have two values locked
and unlocked
. We want to add a new value editing
to it.
ALTER TYPE to Add New Value to Existing Enum
We could easily add a new value to the existing enum using ALTER TYPE
command. Here is how we can do it:
ALTER TYPE gift_card_status_enum ADD VALUE 'editing';