表已经建好后设置字段自增:
CREATE SEQUENCE user_id_seq START WITH 1
INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
alter table user alter column id set default nextval('user_id_seq');
建表时设置自增:
CREATE TABLE user
(
id SERIAL primary key
)
表已经建好后设置字段自增:
CREATE SEQUENCE user_id_seq START WITH 1
INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
alter table user alter column id set default nextval('user_id_seq');
建表时设置自增:
CREATE TABLE user
(
id SERIAL primary key
)