建表语句与导入导出数据

pgsql常用数据类型

建表语句

create table seq_test (
    msid varchar(32),
    timestamp NUMERIC,
    lac varchar(16),
    ci varchar(16),
    flag_01 integer,
    lacci varchar(32),
    lat NUMERIC,
    lon NUMERIC,
    flag_02 integer
)

导入数据

COPY seq_test FROM '/home/hz_cell/seq_test.txt' USING delimiters ',' ;

导出数据

COPY seq_test TO '/home/hz_cell/seq_test02.csv' delimiters ',' csv quote as '"';