Extensions / Functions and aggregates
Generate PostgreSQL WHERE clause predicates from JSONB filter objects.
pgext.cloud · Source code · Documentation · Control file
| Package | pg_json_query |
|---|---|
| Version | 0.9 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | _pg_json_query |
| Stars | 9 |
| Latest commit | 2017-10-18 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| json_build | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. |
| postgres-json-schema | Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. |
| json_utils | JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. |
| json_validator_ext | Validate JSONB values against JSON Schema using Rust and pgrx |
| json_schema_validate | Validate JSON and JSONB data against JSON Schema in PostgreSQL |