postgres 设置主键自增

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

信行合一

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

阅读量5.1k

点赞数

分类专栏： 21_postgres

本文链接：https://blog.csdn.net/tengdazhang770960436/article/details/76610941

版权

21_postgres 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.新建表

CREATE TABLE "public"."t_test" (
"id" int4  NOT NULL,
"name" varchar(255) COLLATE "default",
CONSTRAINT "t_test_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE)
;

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

COMMENT ON COLUMN "public"."t_test"."id" IS '主键';

COMMENT ON COLUMN "public"."t_test"."name" IS '名称';

2.新建序列

CREATE SEQUENCE "public"."t_test_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 9223372036854775807
 START 2
 CACHE 1;

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

SELECT setval('"public"."t_test_id_seq"', 2, true);