1、启动navicat查询窗口，输入如下语句，来创建枚举类型CREATE TYPE sex AS ENUM ('male', 'female');
2、输入如下建表语句CREATE TABLE "public"."enum_type_test" ( "enum_field" sex);
3、输入如下语句，插入枚举记录来测试INSERT INTO "public"."enum_type_test"("enum_field") VALUES ('male');INSERT INTO "public"."enum_type_test"("enum_field") VALUES ('female');
4、输入如下语句，可以查询数据库中存储的记录select * from enum_type_test
5、输入如下语句，来测试插入不在枚举值中的记录，结果会报错INSERT INTO "public"."enum_type_test"("enum_field") VALUES ('test');
6、输入如下语句，来按照枚举值升序排列select * from enum_type_test order by enum_field asc
7、输入如下语句，来按照枚举值降序排列select * from enum_type_test order by enum_field desc
