Extensions
pgjwt

pgjwt

pgjwt : JSON Web Token API for Postgresql

Overview

ID Extension Package Version Category License Language
4160
pgjwt
pgjwt
 0.2.0
UTIL
MIT
SQL
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-dt-
No
Yes
No
Yes
no
yes
Relationships
Requires
pgcrypto
See Also
http
pg_net
pg_curl
pgjq
sparql
pgcrypto
gzip
bzip

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 0.2.0
18
17
16
15
14
13
 pgjwt -
RPM
PIGSTY
 0.2.0
18
17
16
15
14
13
 pgjwt_$v -
DEB
PIGSTY
 0.2.0
18
17
16
15
14
13
 postgresql-$v-pgjwt -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el8.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el10.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el10.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d12.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d12.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d13.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
d13.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u22.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u22.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u24.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
u24.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
Package Version OS ORG SIZE File URL
pgjwt_18 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_18-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_18 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_18-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_18 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_18-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_18 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_18-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_18 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_18-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_18 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_18-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-18-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-18-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-18-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-18-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-18-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-18-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-18-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-18-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-18-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgjwt_17 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_17-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_17 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_17-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_17 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_17-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_17 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_17-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_17 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_17-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_17 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_17-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-17-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-17-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-17-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-17-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-17-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-17-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-17-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgjwt_16 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_16-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_16 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_16-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_16 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_16-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_16 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_16-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_16 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_16-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_16 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_16-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-16-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-16-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-16-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-16-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-16-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-16-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-16-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgjwt_15 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_15-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_15 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_15-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_15 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_15-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_15 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_15-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_15 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_15-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_15 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_15-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-15-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-15-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-15-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-15-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-15-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-15-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-15-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgjwt_14 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_14-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_14 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_14-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_14 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_14-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_14 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_14-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_14 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_14-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_14 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_14-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-14-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-14-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-14-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-14-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-14-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-14-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-14-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgjwt_13 0.2.0 el8.x86_64 pigsty 9.4 KiB pgjwt_13-0.2.0-1PIGSTY.el8.x86_64.rpm
pgjwt_13 0.2.0 el8.aarch64 pigsty 9.3 KiB pgjwt_13-0.2.0-1PIGSTY.el8.aarch64.rpm
pgjwt_13 0.2.0 el9.x86_64 pigsty 9.4 KiB pgjwt_13-0.2.0-1PIGSTY.el9.x86_64.rpm
pgjwt_13 0.2.0 el9.aarch64 pigsty 9.3 KiB pgjwt_13-0.2.0-1PIGSTY.el9.aarch64.rpm
pgjwt_13 0.2.0 el10.x86_64 pigsty 9.5 KiB pgjwt_13-0.2.0-1PIGSTY.el10.x86_64.rpm
pgjwt_13 0.2.0 el10.aarch64 pigsty 9.4 KiB pgjwt_13-0.2.0-1PIGSTY.el10.aarch64.rpm
postgresql-13-pgjwt 0.2.0 d12.x86_64 pigsty 4.1 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-pgjwt 0.2.0 d12.aarch64 pigsty 4.1 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-pgjwt 0.2.0 d13.x86_64 pigsty 4.1 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~trixie_amd64.deb
postgresql-13-pgjwt 0.2.0 d13.aarch64 pigsty 4.1 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~trixie_arm64.deb
postgresql-13-pgjwt 0.2.0 u22.x86_64 pigsty 4.0 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~jammy_amd64.deb
postgresql-13-pgjwt 0.2.0 u22.aarch64 pigsty 4.0 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~jammy_arm64.deb
postgresql-13-pgjwt 0.2.0 u24.x86_64 pigsty 4.0 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~noble_amd64.deb
postgresql-13-pgjwt 0.2.0 u24.aarch64 pigsty 4.0 KiB postgresql-13-pgjwt_0.2.0-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/michelp/pgjwt
 Source Tarball
pgjwt-0.2.0.tar.gz
 
pig build pkg pgjwt;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION pgjwt CASCADE; -- requires pgcrypto
Last updated on
pgjqpg_smtp_client