postgresql 添加列主键自增

1.对已存在的表添加列 和注释

?

1 2	alter table tableName add COLUMN columnName varchar(50); comment on column tableName.columnName is '注释';

2.对已存在的列设置主键

?

1	ALTER TABLE tableName ADD CONSTRAINT xxx_xxx_primary_pk PRIMARY KEY (列);

3.创建自增序列

?

1 2 3 4 5 6

DROP SEQUENCE IF EXISTS {table_name}_nid_seq; CREATE SEQUENCE {table_name}_nid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; alter table trans.{table_name} alter column nid set default nextval('{table_name}_nid_seq');