set id as increment primary key:

CREATE TABLE terminal_products_backup AS TABLE terminal_products;
create sequence id_seq;
alter table terminal_products_backup alter id set default nextval('id_seq');
Select setval('id_seq', mx.mx ) FROM (SELECT MAX(id) AS mx FROM terminal_products_backup) mx;



add  increment primary key  id into table named test1

 ALTER TABLE test1 ADD COLUMN id SERIAL PRIMARY KEY;
0条评论 顺序楼层
请先登录再回复