PostgreSql-主键自增
PgSql中没有自增,可以创建一个序列,将这个序列放在默认值就O;
CREATE SEQUENCE deputy_id_seq START 1001;
ALTER TABLE public.deputy ALTER COLUMN id SET DEFAULT nextval('deputy_id_seq'::regclass);
PgSql中没有自增,可以创建一个序列,将这个序列放在默认值就O;
CREATE SEQUENCE deputy_id_seq START 1001;
ALTER TABLE public.deputy ALTER COLUMN id SET DEFAULT nextval('deputy_id_seq'::regclass);