postgres中自动增长列的设定

最新推荐文章于 2020-05-07 16:03:04 发布

ziyue_2008

最新推荐文章于 2020-05-07 16:03:04 发布

阅读量985

点赞数

文章标签： character null table

本文链接：https://blog.csdn.net/ziyue_2008/article/details/3070593

版权

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)
);