postgresql 导入数据库表并重设自增属性的操作

CREATE SEQUENCE cof_table_hot_analysis_id_seq
  START WITH 1
  INCREMENT BY 1
  NO MINVALUE
  NO MAXVALUE
  CACHE 1;

alter table cof_table_hot_analysis alter column id set default nextval('cof_table_hot_analysis _id_seq ');

select setval('cof_table_hot_analysis_id_seq', 16)

TRUNCATE TABLE cof_table_hot_analysis RESTART IDENTITY

DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
  [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
  [ START [ WITH ] start ]
  [ RESTART [ [ WITH ] restart ] ]
  [ CACHE cache ] [ [ NO ] CYCLE ]
  [ OWNED BY { table.column | NONE } ]
ALTER SEQUENCE name OWNER TO new_owner
ALTER SEQUENCE name RENAME TO new_name
ALTER SEQUENCE name SET SCHEMA new_schema

CREATE SEQUENCE 表名_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

alter table表名 alter column id set default nextval(‘表名_id_seq');

select setval(‘表名_id_seq',(select max(id) from 同一个表名));

select setval('“表名_id_seq”',(select max(id) from “表名”));