text: CREATE TABLE subdivision_CA (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-AB', E'Alberta', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-BC', E'Columbia Britannica', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-MB', E'Manitoba', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-NB', E'Nuovo Brunswick', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-NL', E'Terranova e Labrador', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-NT', E'Territori del Nord-Ovest', E'territory');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-NS', E'Nuova Scozia', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-NU', E'Nunavut', E'territory');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-ON', E'Ontario', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-PE', E'Isola del Principe Edoardo', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-QC', E'Québec', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-SK', E'Saskatchewan', E'province');
  INSERT INTO "subdivision_CA" ("id", "name", "level") VALUES (E'CA-YT', E'Yukon', E'territory');
  