Enum

List enum

SELECT enumlabel
FROM pg_enum
JOIN pg_type ON pg_enum.enumtypid = pg_type.oid
WHERE pg_type.typname = 'fruit'
;

Delete enum locally

DO NOT DO THIS ON PRODUCTION

Say you want to delete apple and kiwi from fruit enum:

DELETE FROM pg_enum
WHERE enumtypid = (SELECT oid FROM pg_type WHERE typname = 'fruit')
  AND enumlabel IN ('kiwi', 'apple')
;