pgsql给已有的表id加自增长

CREATE SEQUENCE auto_incrementew_clerk_customer_info_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
alter table "ew_clerk_customer_info" alter column "id" set default nextval('auto_incrementew_clerk_customer_info_id_seq');
select setval('auto_incrementew_clerk_customer_info_id_seq',(select max("id") from "ew_clerk_customer_info"));

 

创建的时候 就加的

CREATE TABLE "tf_business_group_info" (
  "pid" int4,
  "group_code" varchar(255) NOT NULL,
  "group_name" varchar(50) NOT NULL,
  "business_type" varchar(50) NOT NULL,
  "sort" int4,
  "status" varchar(2) NOT NULL,
  "creator" int4 NOT NULL,
  "create_time" timestamp NOT NULL,
  "operator" int4,
  "update_time" timestamp,
  "id" serial PRIMARY KEY 
);