postgresql id自增张设置和重置序列值

id int4 NOT NULL, -- 数据库自增
--创建一个sequence   seq_region_info
create sequence seq_test increment by 1 minvalue 1 no maxvalue start with 1;
--将需要自增的主键id与seq_region_info关联
ALTER TABLE public.test ALTER COLUMN id SET DEFAULT nextval('seq_test'::regclass);
-- 至此，id便可以实现自增了

postgresql主键删除sequence_PostgreSQL----Sequence序列的那些事
https://blog.csdn.net/weixin_32204175/article/details/113630328

Python 连接 postgreSQL
https://blog.csdn.net/rao356/article/details/125070326

-- eg:

create sequence printing_test_pkey increment by 1 minvalue 1 no maxvalue start with 1;
create sequence spi_test_pkey increment by 1 minvalue 1 no maxvalue start with 1;
create sequence gantry_test_pkey increment by 1 minvalue 1 no maxvalue start with 1;
create sequence reflower_test_pkey increment by 1 minvalue 1 no maxvalue start with 1;
create sequence iot_test_pkey increment by 1 minvalue 1 no maxvalue start with 1;

-- DROP SEQUENCE printing_test_pkey;
-- DROP SEQUENCE spi_test_pkey;
-- DROP SEQUENCE gantry_test_pkey;
-- DROP SEQUENCE reflower_test_pkey;
-- DROP SEQUENCE iot_test_pkey;
-- 1、印刷机
CREATE TABLE "public"."printing_test" (
  "id" int4 NOT NULL DEFAULT nextval('printing_test_pkey'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "contents" varchar(255) COLLATE "pg_catalog"."default",
  "article_type" varchar(255) COLLATE "pg_catalog"."default",
  "author" varchar(255) COLLATE "pg_catalog"."default",
  "status" varchar(255) COLLATE "pg_catalog"."default"
)
;

ALTER TABLE "public"."printing_test"
  OWNER TO "db_user";

-- 2、spi
CREATE TABLE "public"."spi_test" (
  "id" int4 NOT NULL DEFAULT nextval('spi_test_pkey'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "contents" varchar(255) COLLATE "pg_catalog"."default",
  "article_type" varchar(255) COLLATE "pg_catalog"."default",
  "author" varchar(255) COLLATE "pg_catalog"."default",
  "status" varchar(255) COLLATE "pg_catalog"."default")
;

ALTER TABLE "public"."spi_test"
  OWNER TO "db_user";


-- 3、gantry 贴片机
  CREATE TABLE "public"."gantry_test" (
  "id" int4 NOT NULL DEFAULT nextval('gantry_test_pkey'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "contents" varchar(255) COLLATE "pg_catalog"."default",
  "article_type" varchar(255) COLLATE "pg_catalog"."default",
  "author" varchar(255) COLLATE "pg_catalog"."default",
  "status" varchar(255) COLLATE "pg_catalog"."default"
)
;


ALTER TABLE "public"."gantry_test"
  OWNER TO "db_user";


-- 4、reflower  回流焊
  CREATE TABLE "public"."reflower_test" (
  "id" int4 NOT NULL DEFAULT nextval('reflower_test_pkey'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "contents" varchar(255) COLLATE "pg_catalog"."default",
  "article_type" varchar(255) COLLATE "pg_catalog"."default",
  "author" varchar(255) COLLATE "pg_catalog"."default",
  "status" varchar(255) COLLATE "pg_catalog"."default"
)
;

ALTER TABLE "public"."reflower_test"
  OWNER TO "db_user";

-- iot
CREATE TABLE "public"."iot_test" (
  "id" int4 NOT NULL DEFAULT nextval('iot_test_pkey'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "contents" varchar(255) COLLATE "pg_catalog"."default",
  "article_type" varchar(255) COLLATE "pg_catalog"."default",
  "author" varchar(255) COLLATE "pg_catalog"."default",
  "status" varchar(255) COLLATE "pg_catalog"."default"
)
;

ALTER TABLE "public"."iot_test"
  OWNER TO "db_user";

postgresql设置自动更新时间戳方法
https://blog.csdn.net/J926926/article/details/109173738

-- 以下语句使用的是PostgreSQL10
-- 1、创建和删除序列
drop sequence if exists seq_rkdc;
create sequence seq_rkdc start 1;--设置序列从1开始
-- 2、获取序列的值
select nextval('seq_rkdc');
-- 3、重置序列值
alter sequence seq_rkdc restart 1;