select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Data types

pg_postal_code_ca

an efficient, validated, formatted Canadian postal code type

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_postal_code_ca
Version1.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2019-05-05
Catalogue updated2026-08-30

Related extensions

See also

pg_nanpValidated and consistently formatted North American Numbering Plan data type
postcodeStore UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing
emailEmail address data type with validation, equality operators, and user/domain helper functions.
pg_phonenumberC++ libphonenumber-backed phone type, equality operators, and supported-region helpers
telephonePostgreSQL data type for normalized telephone numbers with dialing-plan validation.
ibanIBAN data type and validation functions for PostgreSQL
numeric_domainsCustom numeric domains for PostgreSQL
italian_codesValidation domains for Italian fiscal and VAT codes