select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Features

jsquery

data type for jsonb inspection

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagejsquery
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars710
Latest commit2026-07-02
Latest release2023-10-20
Catalogue updated2026-08-30

Related extensions

Required by

mdbqsMongoDB-style query support for PostgreSQL
monqMongoDB-like query support for jsonb data

See also

pgbsonBSON data type and accessor functions for PostgreSQL
pgjqUse jq in Postgres
pg_jsonschemaPostgreSQL extension providing JSON Schema validation
jsonschemaJSON Schema validation functions for PostgreSQL
pg_projectionMongoDB-like read projections for JSONB in PostgreSQL
documentdbAPI surface for DocumentDB for PostgreSQL
mongo_fdwforeign data wrapper for MongoDB access
jsonb_plperltransform between jsonb and plperl
jsonb_plpython3utransform between jsonb and plpython3u
jsonb_plperlutransform between jsonb and plperlu