pg数据库如何设置自增主键

CREATE SEQUENCE table_name_id_seq;

ALTER TABLE table_name ALTER COLUMN id SET DEFAULT nextval('table_name_id_seq');

ALTER TABLE table_name ADD PRIMARY KEY (id);