country

Country data type, ISO 3166-1

Overview

Package	Version	Category	License	Language
`pg_country`	`0.0.3`	TYPE	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
3660	`country`	No	Yes	No	Yes	No	Yes	-

Related	`isn` `pg_xenophile` `icu_ext` `currency` `asn1oid` `uri` `gb18030_2022` `pg_cjk_parser`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.0.3`	1817161514	`pg_country`	-
RPM	PIGSTY	`0.0.3`	1817161514	`pg_country_$v`	-
DEB	PIGSTY	`0.0.3`	1817161514	`postgresql-$v-pg-country`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.0.3 el8.x86_64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 19.1KiB	PIGSTY 0.0.3 el8.x86_64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 19.1KiB	PIGSTY 0.0.3 el8.x86_64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 19.1KiB	PIGSTY 0.0.3 el8.x86_64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 19.1KiB	PIGSTY 0.0.3 el8.x86_64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 19.1KiB
el8.aarch64	PIGSTY 0.0.3 el8.aarch64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 18.2KiB	PIGSTY 0.0.3 el8.aarch64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 18.2KiB	PIGSTY 0.0.3 el8.aarch64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 18.2KiB	PIGSTY 0.0.3 el8.aarch64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 18.2KiB	PIGSTY 0.0.3 el8.aarch64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 18.2KiB
el9.x86_64	PIGSTY 0.0.3 el9.x86_64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el9.x86_64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el9.x86_64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el9.x86_64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el9.x86_64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB
el9.aarch64	PIGSTY 0.0.3 el9.aarch64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 17.7KiB	PIGSTY 0.0.3 el9.aarch64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 17.6KiB	PIGSTY 0.0.3 el9.aarch64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 17.7KiB	PIGSTY 0.0.3 el9.aarch64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 17.6KiB	PIGSTY 0.0.3 el9.aarch64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 17.6KiB
el10.x86_64	PIGSTY 0.0.3 el10.x86_64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el10.x86_64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el10.x86_64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el10.x86_64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB	PIGSTY 0.0.3 el10.x86_64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 17.0KiB
el10.aarch64	PIGSTY 0.0.3 el10.aarch64.pg18 : pg_country_18 pg_country_18-0.0.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 17.9KiB	PIGSTY 0.0.3 el10.aarch64.pg17 : pg_country_17 pg_country_17-0.0.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 17.9KiB	PIGSTY 0.0.3 el10.aarch64.pg16 : pg_country_16 pg_country_16-0.0.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 17.9KiB	PIGSTY 0.0.3 el10.aarch64.pg15 : pg_country_15 pg_country_15-0.0.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 17.9KiB	PIGSTY 0.0.3 el10.aarch64.pg14 : pg_country_14 pg_country_14-0.0.3-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 17.9KiB
d12.x86_64	PIGSTY 0.0.3 d12.x86_64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 27.8KiB	PIGSTY 0.0.3 d12.x86_64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 28.1KiB	PIGSTY 0.0.3 d12.x86_64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 28.1KiB	PIGSTY 0.0.3 d12.x86_64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 28.1KiB	PIGSTY 0.0.3 d12.x86_64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 28.0KiB
d12.aarch64	PIGSTY 0.0.3 d12.aarch64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 28.3KiB	PIGSTY 0.0.3 d12.aarch64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 28.6KiB	PIGSTY 0.0.3 d12.aarch64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 28.6KiB	PIGSTY 0.0.3 d12.aarch64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 28.5KiB	PIGSTY 0.0.3 d12.aarch64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 28.5KiB
d13.x86_64	PIGSTY 0.0.3 d13.x86_64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 27.8KiB	PIGSTY 0.0.3 d13.x86_64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 27.9KiB	PIGSTY 0.0.3 d13.x86_64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 28.3KiB	PIGSTY 0.0.3 d13.x86_64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 28.0KiB	PIGSTY 0.0.3 d13.x86_64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 27.9KiB
d13.aarch64	PIGSTY 0.0.3 d13.aarch64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 28.5KiB	PIGSTY 0.0.3 d13.aarch64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 28.7KiB	PIGSTY 0.0.3 d13.aarch64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 28.7KiB	PIGSTY 0.0.3 d13.aarch64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 28.8KiB	PIGSTY 0.0.3 d13.aarch64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 28.6KiB
u22.x86_64	PIGSTY 0.0.3 u22.x86_64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 31.6KiB	PIGSTY 0.0.3 u22.x86_64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 32.3KiB	PIGSTY 0.0.3 u22.x86_64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 32.3KiB	PIGSTY 0.0.3 u22.x86_64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 32.3KiB	PIGSTY 0.0.3 u22.x86_64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 32.3KiB
u22.aarch64	PIGSTY 0.0.3 u22.aarch64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 32.6KiB	PIGSTY 0.0.3 u22.aarch64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 32.9KiB	PIGSTY 0.0.3 u22.aarch64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 32.9KiB	PIGSTY 0.0.3 u22.aarch64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 32.9KiB	PIGSTY 0.0.3 u22.aarch64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 32.8KiB
u24.x86_64	PIGSTY 0.0.3 u24.x86_64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 30.7KiB	PIGSTY 0.0.3 u24.x86_64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 30.6KiB	PIGSTY 0.0.3 u24.x86_64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 30.6KiB	PIGSTY 0.0.3 u24.x86_64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 30.6KiB	PIGSTY 0.0.3 u24.x86_64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 30.6KiB
u24.aarch64	PIGSTY 0.0.3 u24.aarch64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 31.3KiB	PIGSTY 0.0.3 u24.aarch64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 31.3KiB	PIGSTY 0.0.3 u24.aarch64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 31.3KiB	PIGSTY 0.0.3 u24.aarch64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 31.3KiB	PIGSTY 0.0.3 u24.aarch64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 31.2KiB
u26.x86_64	PIGSTY 0.0.3 u26.x86_64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 30.0KiB	PIGSTY 0.0.3 u26.x86_64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 29.9KiB	PIGSTY 0.0.3 u26.x86_64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 29.9KiB	PIGSTY 0.0.3 u26.x86_64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 29.9KiB	PIGSTY 0.0.3 u26.x86_64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 29.9KiB
u26.aarch64	PIGSTY 0.0.3 u26.aarch64.pg18 : postgresql-18-pg-country postgresql-18-pg-country_0.0.3-1PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 30.6KiB	PIGSTY 0.0.3 u26.aarch64.pg17 : postgresql-17-pg-country postgresql-17-pg-country_0.0.3-1PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 30.5KiB	PIGSTY 0.0.3 u26.aarch64.pg16 : postgresql-16-pg-country postgresql-16-pg-country_0.0.3-1PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 30.5KiB	PIGSTY 0.0.3 u26.aarch64.pg15 : postgresql-15-pg-country postgresql-15-pg-country_0.0.3-1PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 30.5KiB	PIGSTY 0.0.3 u26.aarch64.pg14 : postgresql-14-pg-country postgresql-14-pg-country_0.0.3-1PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 30.5KiB

Build

You can build the RPM / DEB packages for pg_country using pig build:

pig build pkg pg_country         # build RPM / DEB packages

Install

You can install pg_country directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_country;          # Install for current active PG version

pig

pig ext install -y pg_country -v 18  # PG 18
pig ext install -y pg_country -v 17  # PG 17
pig ext install -y pg_country -v 16  # PG 16
pig ext install -y pg_country -v 15  # PG 15
pig ext install -y pg_country -v 14  # PG 14

dnf

dnf install -y pg_country_18       # PG 18
dnf install -y pg_country_17       # PG 17
dnf install -y pg_country_16       # PG 16
dnf install -y pg_country_15       # PG 15
dnf install -y pg_country_14       # PG 14

apt

apt install -y postgresql-18-pg-country   # PG 18
apt install -y postgresql-17-pg-country   # PG 17
apt install -y postgresql-16-pg-country   # PG 16
apt install -y postgresql-15-pg-country   # PG 15
apt install -y postgresql-14-pg-country   # PG 14

Create Extension:

CREATE EXTENSION country;

Usage

country: ISO 3166-1 alpha-2 country code type

The country extension provides an enumerated data type for ISO 3166-1 alpha-2 country codes with minimal storage overhead.

CREATE EXTENSION country;

CREATE TABLE locations (
    id    serial PRIMARY KEY,
    code  country
);

INSERT INTO locations VALUES (1, 'US'), (2, 'GB'), (3, 'FR');

SELECT * FROM locations ORDER BY code;

Data Type

The country type restricts values to valid ISO 3166-1 alpha-2 codes (two-letter country designations like US, GB, FR, DE, etc.). Invalid codes are rejected on input.

Operators

Standard comparison operators are supported: =, <>, <, >, <=, >=.

Index Support

Both B-tree and hash index operator classes are provided for efficient querying and sorting on country columns.

country

Overview

Version

Build

Install

Usage

Data Type

Operators

Index Support

Was this page helpful?