postgres中自动增长列的设定

CREATE SEQUENCE sendfilteraddrtbl_serial;

 

CREATE TABLE sendfilteraddrtbl (
    customerid character varying(5) NOT NULL,
    serial numeric(18,0) NOT NULL DEFAULT nextval('sendfilteraddrtbl_SERIAL'),
    addr character varying(100) NOT NULL,
    themode numeric(1,0) NOT NULL,
    ruleflag numeric(1,0) NOT NULL,
    attachedrule numeric(1,0) NOT NULL,
    comm character varying(128)
);