country 0.0.4
- This Release
- country 0.0.4
- Date
- Status
- Stable
- Other Releases
- Abstract
- Enumerable country list, stored in a single-byte, fixed-length type.
- Description
- This extnesion effectively provides a country list as an enumerable one-byte integer, ideal for analytics workloads. The country list will be updated as needed.
- Released By
- adjustgmbh
- License
- PostgreSQL
- Resources
- Special Files
Extensions
- country 0.0.4
- Enumerable country list, stored in a single-byte, fixed-length type.
README
Contents
country
A country Extension for PostgreSQL.
The pg-country extension create new data types country, which is a enum types.
The country enumeration values follow the ISO 3166-1 alpha-2 standard.
The extension also creates comparison operators and operator classes for btree and hash indexes.
Installation from source codes
To install country, execute this in the extension's directory:
shell
make install
Testing
To test the country, execute this in the extension's directory:
shell
make installcheck
Notice: Don't forget to set the PG_CONFIG variable (make PG_CONFIG=...)
in case you want to test country on a non-default or custom build of PostgreSQL.
Read more here.