Extensions
jsquery

jsquery

jsquery : data type for jsonb inspection

Overview

ID Extension Package Version Category License Language
2810
jsquery
jsquery
 1.2
FEAT
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_graphql
pg_jsonschema
plv8
jsonb_plperl
jsonb_plpython3u
pg_net
pg_summarize
age

no pg13,12 on el9

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.2
18
17
16
15
14
13
 jsquery -
RPM
PGDG
 1.2
18
17
16
15
14
13
 jsquery_$v* -
DEB
PGDG
 1.2
18
17
16
15
14
13
 postgresql-$v-jsquery -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.1.1
el8.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.1.1
el9.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
MISS
el9.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.1.1
el10.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el10.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
d12.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
d12.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
d13.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
d13.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
u22.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
u22.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
u24.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
u24.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
Package Version OS ORG SIZE File URL
jsquery_18 1.2 el8.x86_64 pgdg 49.3 KiB jsquery_18-1.2-4PGDG.rhel8.x86_64.rpm
jsquery_18 1.2 el8.aarch64 pgdg 46.6 KiB jsquery_18-1.2-4PGDG.rhel8.aarch64.rpm
jsquery_18 1.2 el9.x86_64 pgdg 48.8 KiB jsquery_18-1.2-4PGDG.rhel9.x86_64.rpm
jsquery_18 1.2 el9.aarch64 pgdg 47.5 KiB jsquery_18-1.2-4PGDG.rhel9.aarch64.rpm
jsquery_18 1.2 el10.x86_64 pgdg 50.0 KiB jsquery_18-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_18 1.2 el10.aarch64 pgdg 48.6 KiB jsquery_18-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-18-jsquery 1.2 d12.x86_64 pgdg 123.1 KiB postgresql-18-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-18-jsquery 1.2 d12.aarch64 pgdg 120.1 KiB postgresql-18-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-18-jsquery 1.2 d13.x86_64 pgdg 123.4 KiB postgresql-18-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-18-jsquery 1.2 d13.aarch64 pgdg 120.5 KiB postgresql-18-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-18-jsquery 1.2 u22.x86_64 pgdg 123.8 KiB postgresql-18-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-18-jsquery 1.2 u22.aarch64 pgdg 120.5 KiB postgresql-18-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-18-jsquery 1.2 u24.x86_64 pgdg 122.2 KiB postgresql-18-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-18-jsquery 1.2 u24.aarch64 pgdg 119.9 KiB postgresql-18-jsquery_1.2-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
jsquery_17 1.2 el8.x86_64 pgdg 49.1 KiB jsquery_17-1.2-2PGDG.rhel8.x86_64.rpm
jsquery_17 1.2 el8.aarch64 pgdg 46.6 KiB jsquery_17-1.2-2PGDG.rhel8.aarch64.rpm
jsquery_17 1.2 el9.x86_64 pgdg 48.9 KiB jsquery_17-1.2-2PGDG.rhel9.x86_64.rpm
jsquery_17 1.2 el9.aarch64 pgdg 47.6 KiB jsquery_17-1.2-2PGDG.rhel9.aarch64.rpm
jsquery_17 1.2 el10.x86_64 pgdg 50.0 KiB jsquery_17-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_17 1.2 el10.aarch64 pgdg 48.6 KiB jsquery_17-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-17-jsquery 1.2 d12.x86_64 pgdg 123.1 KiB postgresql-17-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-17-jsquery 1.2 d12.aarch64 pgdg 120.0 KiB postgresql-17-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-17-jsquery 1.2 d13.x86_64 pgdg 123.4 KiB postgresql-17-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-17-jsquery 1.2 d13.aarch64 pgdg 120.3 KiB postgresql-17-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-17-jsquery 1.2 u22.x86_64 pgdg 130.8 KiB postgresql-17-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-17-jsquery 1.2 u22.aarch64 pgdg 127.8 KiB postgresql-17-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-17-jsquery 1.2 u24.x86_64 pgdg 122.3 KiB postgresql-17-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-17-jsquery 1.2 u24.aarch64 pgdg 119.8 KiB postgresql-17-jsquery_1.2-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
jsquery_16 1.2 el8.x86_64 pgdg 49.0 KiB jsquery_16-1.2-1PGDG.rhel8.x86_64.rpm
jsquery_16 1.2 el8.aarch64 pgdg 46.3 KiB jsquery_16-1.2-1PGDG.rhel8.aarch64.rpm
jsquery_16 1.2 el9.x86_64 pgdg 48.5 KiB jsquery_16-1.2-1PGDG.rhel9.x86_64.rpm
jsquery_16 1.2 el9.aarch64 pgdg 47.0 KiB jsquery_16-1.2-1PGDG.rhel9.aarch64.rpm
jsquery_16 1.2 el10.x86_64 pgdg 49.9 KiB jsquery_16-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_16 1.2 el10.aarch64 pgdg 48.4 KiB jsquery_16-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-16-jsquery 1.2 d12.x86_64 pgdg 122.8 KiB postgresql-16-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-16-jsquery 1.2 d12.aarch64 pgdg 119.7 KiB postgresql-16-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-16-jsquery 1.2 d13.x86_64 pgdg 123.1 KiB postgresql-16-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-16-jsquery 1.2 d13.aarch64 pgdg 120.3 KiB postgresql-16-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-16-jsquery 1.2 u22.x86_64 pgdg 130.6 KiB postgresql-16-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-16-jsquery 1.2 u22.aarch64 pgdg 127.6 KiB postgresql-16-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-16-jsquery 1.2 u24.x86_64 pgdg 122.1 KiB postgresql-16-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-16-jsquery 1.2 u24.aarch64 pgdg 119.5 KiB postgresql-16-jsquery_1.2-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
jsquery_15 1.2 el8.x86_64 pgdg 50.3 KiB jsquery_15-1.2-1PGDG.rhel8.x86_64.rpm
jsquery_15 1.2 el8.aarch64 pgdg 47.6 KiB jsquery_15-1.2-1PGDG.rhel8.aarch64.rpm
jsquery_15 1.2 el9.x86_64 pgdg 51.3 KiB jsquery_15-1.2-1PGDG.rhel9.x86_64.rpm
jsquery_15 1.2 el9.aarch64 pgdg 49.6 KiB jsquery_15-1.2-1PGDG.rhel9.aarch64.rpm
jsquery_15 1.2 el10.x86_64 pgdg 52.5 KiB jsquery_15-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_15 1.2 el10.aarch64 pgdg 50.7 KiB jsquery_15-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-15-jsquery 1.2 d12.x86_64 pgdg 124.3 KiB postgresql-15-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-15-jsquery 1.2 d12.aarch64 pgdg 120.9 KiB postgresql-15-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-15-jsquery 1.2 d13.x86_64 pgdg 124.5 KiB postgresql-15-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-15-jsquery 1.2 d13.aarch64 pgdg 121.5 KiB postgresql-15-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-15-jsquery 1.2 u22.x86_64 pgdg 132.6 KiB postgresql-15-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-15-jsquery 1.2 u22.aarch64 pgdg 129.5 KiB postgresql-15-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-15-jsquery 1.2 u24.x86_64 pgdg 124.2 KiB postgresql-15-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-15-jsquery 1.2 u24.aarch64 pgdg 121.2 KiB postgresql-15-jsquery_1.2-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
jsquery_14 1.2 el8.x86_64 pgdg 50.3 KiB jsquery_14-1.2-1PGDG.rhel8.x86_64.rpm
jsquery_14 1.2 el8.aarch64 pgdg 47.6 KiB jsquery_14-1.2-1PGDG.rhel8.aarch64.rpm
jsquery_14 1.2 el9.x86_64 pgdg 51.3 KiB jsquery_14-1.2-1PGDG.rhel9.x86_64.rpm
jsquery_14 1.2 el9.aarch64 pgdg 49.7 KiB jsquery_14-1.2-1PGDG.rhel9.aarch64.rpm
jsquery_14 1.2 el10.x86_64 pgdg 52.5 KiB jsquery_14-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_14 1.2 el10.aarch64 pgdg 50.7 KiB jsquery_14-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-14-jsquery 1.2 d12.x86_64 pgdg 124.3 KiB postgresql-14-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-14-jsquery 1.2 d12.aarch64 pgdg 121.0 KiB postgresql-14-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-14-jsquery 1.2 d13.x86_64 pgdg 124.3 KiB postgresql-14-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-14-jsquery 1.2 d13.aarch64 pgdg 121.3 KiB postgresql-14-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-14-jsquery 1.2 u22.x86_64 pgdg 132.6 KiB postgresql-14-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-14-jsquery 1.2 u22.aarch64 pgdg 129.3 KiB postgresql-14-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-14-jsquery 1.2 u24.x86_64 pgdg 124.2 KiB postgresql-14-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-14-jsquery 1.2 u24.aarch64 pgdg 121.3 KiB postgresql-14-jsquery_1.2-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
jsquery_13 1.1.1 el8.x86_64 pgdg 138.3 KiB jsquery_13-1.1.1-2.rhel8.x86_64.rpm
jsquery_13 1.1.1 el8.aarch64 pgdg 136.7 KiB jsquery_13-1.1.1-2.rhel8.aarch64.rpm
jsquery_13 1.1.1 el9.aarch64 pgdg 140.7 KiB jsquery_13-1.1.1-2.rhel9.aarch64.rpm
jsquery_13 1.2 el10.x86_64 pgdg 52.5 KiB jsquery_13-1.2-4PGDG.rhel10.x86_64.rpm
jsquery_13 1.2 el10.aarch64 pgdg 50.7 KiB jsquery_13-1.2-4PGDG.rhel10.aarch64.rpm
postgresql-13-jsquery 1.2 d12.x86_64 pgdg 124.1 KiB postgresql-13-jsquery_1.2-3.pgdg12+1_amd64.deb
postgresql-13-jsquery 1.2 d12.aarch64 pgdg 120.8 KiB postgresql-13-jsquery_1.2-3.pgdg12+1_arm64.deb
postgresql-13-jsquery 1.2 d13.x86_64 pgdg 124.3 KiB postgresql-13-jsquery_1.2-3.pgdg13+1_amd64.deb
postgresql-13-jsquery 1.2 d13.aarch64 pgdg 121.1 KiB postgresql-13-jsquery_1.2-3.pgdg13+1_arm64.deb
postgresql-13-jsquery 1.2 u22.x86_64 pgdg 132.4 KiB postgresql-13-jsquery_1.2-3.pgdg22.04+1_amd64.deb
postgresql-13-jsquery 1.2 u22.aarch64 pgdg 129.1 KiB postgresql-13-jsquery_1.2-3.pgdg22.04+1_arm64.deb
postgresql-13-jsquery 1.2 u24.x86_64 pgdg 124.0 KiB postgresql-13-jsquery_1.2-3.pgdg24.04+1_amd64.deb
postgresql-13-jsquery 1.2 u24.aarch64 pgdg 121.2 KiB postgresql-13-jsquery_1.2-3.pgdg24.04+1_arm64.deb

Source

Repository
github.com/postgrespro/jsquery
 Source Tarball
jsquery-1.2.tar.gz
 
pig build pkg jsquery;		# build spec not ready

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install jsquery;		# install via package name, for the active PG version

pig install jsquery -v 18;   # install for PG 18
pig install jsquery -v 17;   # install for PG 17
pig install jsquery -v 16;   # install for PG 16
pig install jsquery -v 15;   # install for PG 15
pig install jsquery -v 14;   # install for PG 14
pig install jsquery -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION jsquery;
Last updated on
pg_jsonschemapg_hint_plan