1.geom扩展安装
postgis
2.类型 "geometry" 不存在
CREATE EXTENSION postgis
3."zhumadian617_gid_seq“不存在
DROP SEQUENCE IF EXISTS xxx_id_seq;
CREATE SEQUENCE xxx_id_seq;
4.查看所有的序列
SELECT sequence_schema, sequence_name FROM information_schema.sequences;
5.创建id自动递增
①CREATE SEQUENCE zmd_tif_id_seq START 1;
②在字段中设置默认值
6.删除序列
drop SEQUENCE field_tr_1_gid_seq;