postgres 创建自增序列

最新推荐文章于 2024-04-28 14:54:05 发布

i自由

最新推荐文章于 2024-04-28 14:54:05 发布

阅读量988

点赞数 1

文章标签： java leetcode 算法 c++ postgresql

本文链接：https://blog.csdn.net/WoBenZiYou/article/details/108255607

版权

建表时添加自增序列和主键

CREATE TABLE users
(
id SERIAL primary key ,
  "admin_id" int4,
  "acc_id" int4,
);

ALTER TABLE "public"."im_group_kick_out_record" 
  OWNER TO "postgres";

给已有表增加自增序列

ALTER TABLE "public"."im_group_kick_out_record" 
  OWNER TO "postgres";


CREATE SEQUENCE im_group_kick_out_record_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
 
alter table im_group_kick_out_record alter column id set default nextval('im_group_kick_out_record_id_seq');