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

 

 

 

转载于:https://my.oschina.net/u/3346425/blog/1810037