1.创建枚举类型
create type ods.type_construction as enum ('坑槽修补', '绿化修剪', '测试');
2.查看所有枚举
select * from pg_enum
3.向枚举类型中添加新的枚举数据
alter type ods.type_construction add value '测试' ;ALTER TYPE enum_type ADD VALUE 'new_value'; -- appends to listALTER TYPE enum_type ADD VALUE 'new_value' BEFORE 'old_value';ALTER TYPE enum_type ADD VALUE 'new_value' AFTER 'old_value';