pgsql主键自增

nextval('dm_scm_rel_ioc_user_probe_id_seq'::regclass)

nextval('dm_scm_rel_ioc_task_id_seq'::regclass)

nextval('rel_regioc_risk_task_id_seq'::regclass)

 

CREATE SEQUENCE rel_regioc_risk_task_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1; 

 

alter table rel_regioc_risk_task alter column id set default nextval(rel_regioc_risk_task_id_seq); 

 

postgresql数据库如何实现主键自增            https://blog.csdn.net/lqq1667821818/article/details/117789241