select open change scope Open full search

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

Extensions / Data types

pair

A key/value pair data type for PostgreSQL

pgext.cloud · Source code · Documentation · Control file · PGXN

Overview

Packagepair
Version0.1.2
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars12
Latest commit2026-06-08
Latest release2025-04-29
Catalogue updated2026-08-30

Related extensions

See also

hstoredata type for storing sets of (key, value) pairs
istoreInteger-to-integer key/value store for analytic workloads.
kv_fdwForeign data wrapper for key-value storage backed by RocksDB/VidarDB.
pgkvRedis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions
pg_consulC++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs.
lsmRocksDB foreign data wrapper for PostgreSQL
session_variablesSQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings.
hstore_plluaHstore transform for Lua