JDBC：Java中枚举类型和PostgreSQL数据库中枚举类型的映射

CREATE TYPE animal_type AS ENUM('DOG', 'CAT', 'SQUIRREL');

create table pet (
                  pet_id        integer         not null,
                  pet_type      animal_type     not null,
                  name          varchar(20)     not null
                  );

public enum AnimalType {
    DOG,
    CAT,
    SQUIRREL;
 }

INSERT INTO pet (pet_id, pet_type, name) VALUES (?, CAST(? AS animal_type), ?);

INSERT INTO pet (pet_id, pet_type, name) VALUES (?, ?::animal_type, ?);

stmt.setInt(1, 1);
stmt.setString(2, AnimalType.DOG.toString());
stmt.setString(3, 'Rex');

AnimalType.valueOf(stmt.getString("pet_type"));

SELECT enumlabel FROM pg_enum
    WHERE enumtypid = 'your_enum'::regtype ORDER BY oid;