在PostgreSQL数据库中插入带有jOOQ的SQL枚举

CREATE TYPE status AS ENUM ('active', 'inactive', 'pending');

CREATE TYPE status AS ENUM ('active', 'inactive', 'pending');

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    status status
);

public class Users extends TableImpl<UsersRecord> {
    public static final Users USERS = new Users();
    public final TableField<UsersRecord, String> NAME = createField(DSL.name("name"), SQLDataType.VARCHAR(100).nullable(false), this, "");
    public final TableField<UsersRecord, Status> STATUS = createField(DSL.name("status"), SQLDataType.OTHER.asEnum(Status.class), this, "");
    // other fields and methods
}

public enum Status {
    ACTIVE,
    INACTIVE,
    PENDING
}

import org.jooq.DSLContext;
import org.jooq.impl.DSL;

public class Main {
    public static void main(String[] args) {
        DSLContext dsl = DSL.using(connection, SQLDialect.POSTGRES);

        dsl.insertInto(Users.USERS)
           .set(Users.USERS.NAME, "John Doe")
           .set(Users.USERS.STATUS, Status.ACTIVE)
           .execute();
    }
}

CREATE TYPE status AS ENUM ('active', 'inactive', 'pending');
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    status status
);

dsl.insertInto(Users.USERS)
   .set(Users.USERS.NAME, "John Doe")
   .set(Users.USERS.STATUS, Status.ACTIVE) // 确保Status.ACTIVE是有效的枚举值
   .execute();

jooq-codegen --database postgres --inputSchema public --target /path/to/output