CREATE TYPE public.message_type AS ENUM
(':text', ':image', ':voice', 'video', ':product');

ADD VALUE (PG 9.x)
=========
ALTER TYPE message_type ADD VALUE ':video';

RENAME VALUE (PG 10.x)
=============
ALTER TYPE message_type RENAME VALUE 'video' TO ':video';