PIGSTY

hstore

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

Repository

https://www.postgresql.org/docs/current/hstore.html

Overview

3970hstorehstore1.8
TYPE
PostgreSQL
C

Attributes

YesNoYesNoYesUnknownYes-

Packages

EL
CONTRIB
postgresql$v-contrib1.8-
18
17
16
15
14
13
Debian
CONTRIB
postgresql-$v1.8-
18
17
16
15
14
13

See Also

hstore_pllua
hstore_plluau
hstore_plpython3u
pg_readme
pg_readme_test_extension
intarray
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap
pgfaceting
pg_sphere
country
pg_xenophile
l10n_table_dependent_extension
currency

Dependent Extensions

The following extensions depend on this extension: hstore_pllua, hstore_plluau, hstore_plpython3u, pg_readme, pg_readme_test_extension

Availability

PG18PG17PG16PG15PG14PG13
el8.x86_64
1.8
1.8
1.8
1.8
1.8
1.8
el8.aarch64
1.8
1.8
1.8
1.8
1.8
1.8
el9.x86_64
1.8
1.8
1.8
1.8
1.8
1.8
el9.aarch64
1.8
1.8
1.8
1.8
1.8
1.8
d12.x86_64
1.8
1.8
1.8
1.8
1.8
1.8
d12.aarch64
1.8
1.8
1.8
1.8
1.8
1.8
u22.x86_64
1.8
1.8
1.8
1.8
1.8
1.8
u22.aarch64
1.8
1.8
1.8
1.8
1.8
1.8
u24.x86_64
1.8
1.8
1.8
1.8
1.8
1.8
u24.aarch64
1.8
1.8
1.8
1.8
1.8
1.8
CONTRIB
PGDG
PIGSTY

Download

This extension is built-in with PostgreSQL and does not need separate download.

Install

Extension hstore is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Create this extension with:
CREATE EXTENSION hstore;