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: March 4, 2018
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`));