pg数据库主键重置，从1递增

清空表数据
重置主键从1递增

TRUNCATE entity;
TRUNCATE entity RESTART IDENTITY;

# 设置主键递增
# nextval('entity_id_seq'::regclass)

# 自增设置
create table test_b(

id serial PRIMARY KEY,
name character varying(128)
);

# 清空表数据，重置主键从1递增
TRUNCATE entity;
TRUNCATE entity RESTART IDENTITY;

insert into entity_content(id, entity_id, sens_text, triplet) VALUES (1, '13', '数学', '[]')

insert into entity_content(entity_id, sens_text, triplet) VALUES ('14', '语文', '[]')

# 从最大值开始增，防止插入冲突
select setval('entity_content_id_seq', (select max(id) from entity_content))