Question

postgresql如何让主键自增

Answer 1

postgresql如何让主键自增

法一：
?

1
2
3
4
5
6
7
8
9

Sql代码
CREATE TABLE customers
(
customerid SERIAL primary key ,
companyname character varying,
contactname character varying,
phone character varying,
country character varying
)

法二：
?

1
2
3
4
5
6
7
8
9

Sql代码
CREATE SEQUENCE event_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

alter table event alter column id set default nextval('event_id_seq');

2种方法都可以，第一种简单点。