country
Country data type, ISO 3166-1
Module:
Categories:
Overview
PIGSTY 3rd Party Extension: pg_country
: Country data type, ISO 3166-1
Information
- Extension ID: 3600
- Extension Name:
country
- Package Name:
pg_country
- Category:
TYPE
- License: PostgreSQL
- Website: https://github.com/adjust/pg-country
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 0.0.3
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_country_$v*
- RPM Ver :
0.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-country
- DEB Ver :
0.0.3
- DEB Deps: N/A
Packages
Installation
Install country
via the pig
CLI tool:
pig ext install pg_country; # Extension Namepig ext install country; # normalized package name
Install pg_country
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_country"]}' # -l <cls>
Install pg_country
RPM from YUM repo directly:
dnf install pg_country_17*;
dnf install pg_country_16*;
dnf install pg_country_15*;
dnf install pg_country_14*;
dnf install pg_country_13*;
Install pg_country
DEB from APT repo directly:
apt install postgresql-17-pg-country;
apt install postgresql-16-pg-country;
apt install postgresql-15-pg-country;
apt install postgresql-14-pg-country;
apt install postgresql-13-pg-country;
Enable country
extension on PostgreSQL cluster:
CREATE EXTENSION country;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.