Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2
pgext.cloud · Source code · Documentation · Control file · PGXN
| Package | json_enhancements |
|---|---|
| Version | 1.0.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Archived |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Catalogue updated | 2026-07-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| json_build | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| hstore_ops | Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries. |
| hstore_hash_ops | PostgreSQL hstore GIN operator classes: hash and exact pair indexes |
| jsquery | data type for jsonb inspection |
| hstore | data type for storing sets of (key, value) pairs |
| aggs_for_vecs | Aggregate functions for array inputs |
| pgjq | Use jq in Postgres |
| istore | Integer-to-integer key/value store for analytic workloads. |
| json_enhancements_with_hstore | Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2 |