select open change scope Open full search

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

Extensions / Features

hstore_ops

Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagehstore_ops
Version1.1
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars16
Latest commit2023-11-13
Catalogue updated2026-08-30

Related extensions

Requires

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

See also

hstoredata type for storing sets of (key, value) pairs
hstore_hash_opsPostgreSQL hstore GIN operator classes: hash and exact pair indexes
hstore_plluauHstore transform for untrusted Lua
istoreInteger-to-integer key/value store for analytic workloads.
hstore_plperltransform between hstore and plperl
hstore_plpython3utransform between hstore and plpython3u
hstore_plperlutransform between hstore and plperlu
fluxLogs table data changes and reconstructs rows as they existed in the past.