postgres 身份证前6位省市匹配表

postgresql身份证前6位省市匹配表,可自己转化为mysql或者Oracle,表结构:CREATE TABLE "public"."area" ( "id" int4 NOT NULL, "code" varchar(255) COLLATE "pg_catalog"."default", "province" varchar(255) COLLATE "pg_catalog"."default", "city" varchar(255) COLLATE "pg_catalog"."default" )