自动生成表id

Question

我使用这个SQL查询将测试数据生成到表中：

INSERT into onboarding_tasks SELECT generate_series(1,10) AS id,
    ('ABC name ' || generate_series(1,10)) AS business_name;

如你所见，id范围的数字是固定的，如果出错，我会得到副本。如何以数据库自动生成id的方式编辑此SQL查询？

在Hibernate中，我使用以下代码来创建id：

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", unique = true, updatable = false, nullable = false)
private Long id;

Answer 1

您将首先定义该表：

create table onboarding_tasks (
    id int generated always as identity,
    business_name text
);

INSERT into onboarding_tasks (business_name)
    SELECT ('ABC name ' || generate_series(1,10)) AS business_name;