I recently had trouble manipulating an ENUM field I had created in PostgreSQL. I couldn’t find any suggestions or samples easily on Google or in the manual and was able to get it to work, so I post it here. The basic premise is there is an ENUM field type created, I need more possible values and to preserve the existing values I already have to keep code working.