select open change scope Open full search

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

Extensions / Data types

hstore

data type for storing sets of (key, value) pairs

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagehstore
Version1.8
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

fluxLogs table data changes and reconstructs rows as they existed in the past.
formatA string formatting function which takes named parameters
hstore_hash_opsPostgreSQL hstore GIN operator classes: hash and exact pair indexes
hstore_opsAlternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.
hstore_plluaHstore transform for Lua
hstore_plluauHstore transform for untrusted Lua
hstore_plperltransform between hstore and plperl
hstore_plperlutransform between hstore and plperlu
hstore_plphpTransform between hstore and PHP associative arrays for PL/php
hstore_plpython2utransform between hstore and plpython2u
hstore_plpython3utransform between hstore and plpython3u
hstore_plpythonutransform between hstore and plpythonu
hstore_plrubyTransform between hstore and Ruby Hashes for PL/Ruby
json_enhancements_with_hstoreBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2
mbussimple message bus for pg
meta_triggersInsert, update and delete triggers for the meta system catalog
numhstoreAdds inthstore and floathstore numeric hstore types and helpers
pg_auditorAudit data changes and provide flashback ability
pg_readmeGenerate a Markdown README from PostgreSQL COMMENT objects
pg_rowalescerowalesce() is like coalesce(), but for rows and other composite types.
pg_utility_trigger_functionsSome pet trigger functions that the extension author likes to follow him through various PostgreSQL projects.
pg_xenophileMore than the bare necessities for PostgreSQL i18n and l10n.
sys_syn_dblinkPL/pgSQL synchronization processor that pulls sys_syn queues over named dblink connections, transforms batches, writes local tables, and returns processing status to the source database.

See also

pgbsonBSON data type and accessor functions for PostgreSQL
collectionAssociative-array data types for high-performance PL/pgSQL workflows
jsonschemaJSON Schema validation functions for PostgreSQL
pgjqUse jq in Postgres
jsquerydata type for jsonb inspection
pg_jsonschemaPostgreSQL extension providing JSON Schema validation
intarrayfunctions, operators, and index support for 1-D arrays of integers
arraymathArray math and operators that work element by element on the contents of arrays
pgpdfPDF type with meta admin & Full-Text Search
pglite_fusionEmbed an SQLite database in your PostgreSQL table