PostgreSQL 创建自增序列(索引)

 

方式 1:

                    
CREATE TABLE "public"."table1" (
 "id" serial NOT NULL, // 使用 serial ,数据库会自动创建对应的索引 table1_id_seq 
 "status" varchar(3) COLLATE "pg_catalog"."default",
 "creator" varchar(50) COLLATE "pg_catalog"."default",
 "create_date" timestamptz(6),
 "modifier" varchar(50) COLLATE "pg_catalog"."default",
 "modify_date" timestamp(6)
); 

方式 2:

                    

                                    
CREATE SEQUENCE "public". "table1_id_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 9223372036854775807
 START 21
 CACHE 1;
                                            
 CREATE TABLE "public"."table1" (
 "id" int4 NOT NULL DEFAULT nextval('table1_id_seq'::regclass),
 "status" varchar(3) COLLATE "pg_catalog"."default",
 "creator" varchar(50) COLLATE "pg_catalog"."default",
 "create_date" timestamptz(6),
 "modifier" varchar(50) COLLATE "pg_catalog"."default",
 "modify_date" timestamp(6)
); 

 

PostgreSQL 自增序列从 1 开始

alter sequence table1_id_seq restart with 1;

 

PostgreSQL 高效清空表数据

truncate table table1;