The Lite Edition contains a complete listing of all Canadian postal codes with city and province cross-reference.
This is a basic postal code database suitable for applications that need to perform simple validation of Canadian Postal Codes.
Produced: on or before 5th calendar day quarterly
Current Release: November 3, 2017
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
|Field||Data Type||Field Description|
|PostalCode||CHAR(7)||The six character Postal Code.|
|City||VARCHAR(64)||The preferred name for the city, town, or unique organization.|
|Province||CHAR(2)||Two character abbreviation of the province or territory.|
|PostalCodeType||CHAR(1)||Specifies the basic category of the Postal Code (R)ural or (U)rban|
CREATE DATABASE IF NOT EXISTS `postalcodelite`; USE `postalcodelite`; DROP TABLE IF EXISTS `postalcodes`; CREATE TABLE `postalcodes` ( `PostalCode` CHAR(7) NOT NULL, `City` VARCHAR(64) DEFAULT NULL, `Province` CHAR(2) DEFAULT NULL, `PostalCodeType` CHAR(1) DEFAULT NULL, PRIMARY KEY (`PostalCode`));