首页 > 数据库 >pgsql主键自增

pgsql主键自增

时间:2022-12-04 15:13:10浏览次数:37  
标签:自增 task risk seq nextval id pgsql rel 主键

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

标签:自增,task,risk,seq,nextval,id,pgsql,rel,主键
From: https://www.cnblogs.com/mingruifeng/p/16949910.html

相关文章