1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| CREATE TABLE "public"."pays" (
"country" VARCHAR NOT NULL,
"language" VARCHAR NOT NULL,
"id" VARCHAR NOT NULL,
"iso2" VARCHAR NOT NULL,
"region1" VARCHAR NOT NULL,
"region2" VARCHAR NOT NULL,
"region3" VARCHAR NOT NULL,
"region4" VARCHAR NOT NULL,
"zip" VARCHAR NOT NULL,
"city" VARCHAR NOT NULL,
"area1" VARCHAR NOT NULL,
"area2" VARCHAR NOT NULL,
"lat" VARCHAR NOT NULL,
"lng" VARCHAR NOT NULL,
"tz" VARCHAR NOT NULL,
"utc" VARCHAR NOT NULL,
"dst" VARCHAR NOT NULL,
"city_fr" VARCHAR,
"city_de" VARCHAR,
"city_fr_de" VARCHAR,
"region_fr" VARCHAR,
"region_de" VARCHAR,
"region_fr_de" VARCHAR,
"region_2_fr" VARCHAR,
"region_2_de" VARCHAR,
"region_2_fr_de" VARCHAR,
"geom" "public"."geometry",
"ville_region_id" BIGINT,
"all_zip" VARCHAR
) WITHOUT OIDS; |
Partager