JSON data type, operators, and functions backed by the Jansson JSON library.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | jansson-json |
|---|---|
| Version | 0.0.2 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 7 |
| Latest commit | 2013-02-03 |
| Latest release | 2011-09-05 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| json_utils | JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. |
| json_model | JSON Model PL/pgSQL Runtime - JSON value validation |
| json_fdw | Foreign data wrapper for local and remote JSON document access. |
| json_schema_validate | Validate JSON and JSONB data against JSON Schema in PostgreSQL |
| json_build | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. |