Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing
pgext.cloud · Source code · Website · Documentation · License text · Control file · PGXN
| Package | postcode |
|---|---|
| Version | 1.3.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 6 |
| Latest commit | 2015-03-07 |
| Latest release | 2015-03-06 |
| Catalogue updated | 2026-08-30 |
| pg_postal_code_ca | an efficient, validated, formatted Canadian postal code type |
| pg_sexp | Adds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing. |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| ksj | Japanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing |
| lsm3 | LSM tree index access method based on PostgreSQL B-tree indexes |
| pg_fraction | Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. |
| tinyint | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. |
| span | C data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors. |