由于postgresql和mysql的使用方式不同,所以不能直接导出sql转换为mysql所用的,所以
下面是我总结的几点
DROP TABLE IF EXISTS "public"."college";
CREATE TABLE "public"."college" (
"college_id" int4 DEFAULT nextval('college_college_id_seq'::regclass) NOT NULL,
"college_code" varchar(50) COLLATE "default" NOT NULL,
"college_name" varchar(100) COLLATE "default" NOT NULL,
"college_web_site" varchar(50) COLLATE "default",
"standby0" varchar(500) COLLATE "default",
"standby4" varchar(500) COLLATE "default",
"standby3" varchar(500) COLLATE "default",
"standby2" varchar(500) COLLATE "default",
"standby1" varchar(500) COLLATE "default"
)
WITH (OIDS=FALSE)
;
-- ----------