select open change scope Open full search

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

Extensions / Data types

pg_nanp

Validated and consistently formatted North American Numbering Plan data type

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

Overview

Packagepg_nanp
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_postal_code_caan efficient, validated, formatted Canadian postal code type
phone_numberA pgrx PostgreSQL data type and random generator for structured mobile phone numbers.
telephonePostgreSQL data type for normalized telephone numbers with dialing-plan validation.
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
ibanIBAN data type and validation functions for PostgreSQL
numeric_domainsCustom numeric domains for PostgreSQL
italian_codesValidation domains for Italian fiscal and VAT codes