mysql 导入postgressql_mysql 导入数据到postgresql

创建PG的表脚本

DROP TABLE IF EXISTS "public"."t_resource_info";

CREATE TABLE"public"."t_resource_info"("area_code" varchar(255) COLLATE "pg_catalog"."default"NOT NULL DEFAULT NULL::character varying,"id"int4 NOT NULL DEFAULT NULL,"resource_title" varchar(1024) COLLATE "pg_catalog"."default"NOT NULL DEFAULT NULL::character varying,"resource_format" varchar(16) COLLATE "pg_catalog"."default"NOT NULL DEFAULT NULL::character varying,"resource_size_int"int8 NOT NULL DEFAULT NULL,"create_time" timestamp(6) NOT NULL DEFAULT NULL::timestamp without time zone,"down_count" int4 NOT NULL DEFAULT 0,"file_id" char(36) COLLATE "pg_catalog"."default"NOT NULL DEFAULT NULL::bpchar,"thumb_id" char(36) COLLATE "pg_catalog"."default" NOT NULL DEFAULT '1'::bpchar,"res