Canadian Postal Codes - Standard Edition Home > Canadian Postal Codes > Lite Edition

Canadian Postal Codes

Lite Edition

Canadian Postal Codes

Produced: on or before 5th calendar day quarterly
Current Release: October 5, 2016
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download

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.

  • Data Field Definitions
  • SQL Table Definitions
  • Postal Code Assignments
FieldData TypeField Description
PostalCodeCHAR(7)The six character Postal Code.
CityVARCHAR(64)The preferred name for the city, town, or unique organization.
ProvinceCHAR(2)Two character abbreviation of the province or territory.
PostalCodeTypeCHAR(1)Specifies the basic category of the Postal Code (R)ural or (U)rban
USE `postalcodelite`;

DROP TABLE IF EXISTS `postalcodes`;
CREATE TABLE `postalcodes` (
	`PostalCode` CHAR(7) NOT NULL,
	`Province` CHAR(2) DEFAULT NULL,
	`PostalCodeType` CHAR(1) DEFAULT NULL,
	PRIMARY KEY (`PostalCode`));

Corporate License

Single release

Annual subscription - quarterly updates

Distribution License

Annual subscription - quarterly updates

pdf file Reference Manual
zipped file Sample Data