Extensions / Functions and aggregates
hstore-style functions and operators for jsonb
pgext.cloud · Source code · Control file
| Package | jsonb_opx |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 1 |
| Latest commit | 2015-03-08 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsonb_delete | hstore-style delete function and operator for jsonb |
| pgkv | Redis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| format_x | Polymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values. |
| zson | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. |
| jsonb_extend | Merge two or more jsonb values |
| jsonb_extra | Extra JSONB functions |
| jsonb_deep_sum | Recursively sum numeric fields in JSONB objects |