DEV Community

Discussion on: Dealing with Enum Type in PostgreSQL

View post

Replies for: Hey Yogi, thanks for the great post. How are you handling migrations where some of the enum values are removed? Existing data are using an enum val...

Collapse
 
crazyoptimist profile image
crazyoptimist • • Edited

I've figured it out.

ALTER TYPE delivery_status RENAME VALUE 'PREPARING' TO 'PACKAGING' ;
Enter fullscreen mode Exit fullscreen mode

This query worked out brilliantly.
Thanks again.