postgre 自增序列

先建立一个序列

create sequence id_seq start with 1 increment by 1 no minvalue no maxvalue cache 1;

创建表的时候这样写：

    create table dws_customize_filter_test (
    id   int4 default nextval('id_seq'),
    create_time TIMESTAMP not null default CURRENT_TIMESTAMP,
    update_time  TIMESTAMP not null default CURRENT_TIMESTAMP ,
    status varchar DEFAULT 1,
    kpi varchar, 
    dimention varchar,
    table_name varchar,
    clc_mode varchar
    )