hstore

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

Overview

ID	Extension	Package	Version	Category	License	Language
3970	hstore	hstore	`1.8`	TYPE	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
Need By	hstore_pllua hstore_plluau hstore_plpython3u pg_readme pg_readme_test_extension
See Also	intarray prefix semver unit pgpdf pglite_fusion md5hash asn1oid

PG18	PG17	PG16	PG15	PG14	PG13
1.8	1.8	1.8	1.8	1.8	1.8

This is a built-in contrib extension ship with the PostgreSQL kernel

Create this extension with:

CREATE EXTENSION hstore;

Last updated on 2025-10-28