PostgreSQL的創建自動遞增的主鍵

方法1:

CREATE TABLE test_b 
( 
  id serial PRIMARY KEY, 
  name character varying(128) 
); 

方法2:

CREATE TABLE test_c 
( 
  id integer PRIMARY KEY, 
  name character varying(128) 
);  

CREATE SEQUENCE test_c_id_seq 
    START WITH 1 
    INCREMENT BY 1 
    NO MINVALUE 
    NO MAXVALUE 
    CACHE 1;

alter table test_c alter column id set default nextval('test_c_id_seq');