postgresql如何让主键自增
法一：CREATE TABLE customers
(
customerid SERIAL primary key ,
companyname character varying,
contactname character varying,
phone character varying,
country character varying
)
法二：
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种方法都可以，第一种简单点。
refurl:http://bbs.csdn.net/topics/340003365
http://blog.csdn.net/zezeshenshi/article/details/8542274
页:
[1]