pg库数据迁移(序列sequence报错,geom报错)
geom报错
[ERR] 1> ERROR: type “public.geometry” does not exist
LINE 13: “geom” “public”.“geometry”,
^
[DTF] Process terminated
geom报错解决
是因为没有安装postgis
CREATE EXTENSION postgis;
序列报错解决
1. 创建序列在迁移 可直接运行sql文件
CREATE SEQUENCE pipeline_test_id_seq START 1;