hstore
data type for storing sets of (key, value) pairs
Overview
| 3970 | hstore | hstore | 1.8 | TYPE | PostgreSQL | C |
Attributes
| Yes | No | Yes | No | Yes | Unknown | Yes | - |
Packages
| EL | CONTRIB | postgresql$v-contrib | 1.8 | - | 17 16 15 14 13 |
| Debian | CONTRIB | postgresql-$v | 1.8 | - | 17 16 15 14 13 |
Dependent Extensions
The following extensions depend on this extension: hstore_pllua, hstore_plluau, hstore_plpython3u, pg_readme, pg_readme_test_extension
Availability
| PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|
el8.x86_64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
el8.aarch64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
el9.x86_64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
el9.aarch64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
d12.x86_64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
d12.aarch64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
u22.x86_64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
u22.aarch64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
u24.x86_64 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
u24.aarch64 | 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 on PostgreSQL database with:
CREATE EXTENSION hstore;