← Browse the extensions catalog

pg-session-jwt

Source README ↗

Overview

pg_session_jwt is a PostgreSQL extension for managing authenticated sessions through JSON Web Tokens (JWTs). With a JSON Web Key (JWK), it verifies JWT authenticity and exposes the validated claims to SQL. Without a JWK, it can use PostgREST- compatible JWT claims for identifying the current user.

Package details

Extension version
0.5.0
Image built
Publisher
cnpg-extensions
Build
PGRX
Platform
PG 18 · Trixie · amd64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_session_jwt;
SQL version
0.5.0

PostgreSQL parameters

None specified

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Unavailable

Extension recipe
Apache-2.0

License expressions in the shipped package inventory

  • MIT OR Apache-2.033 packages
  • MIT13 packages
  • Apache-2.0 OR MIT10 packages
  • BSD-3-Clause3 packages
  • Unlicense OR MIT2 packages
  • (MIT OR Apache-2.0) AND Unicode-3.01 package
  • Apache-2.01 package
  • GPL-2.0-only AND GPL-2.0-or-later AND LicenseRef-verbatim1 package
1 more license expressions
  • Zlib1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

24 files read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_session_jwt is a PostgreSQL extension for managing authenticated sessions through JSON Web Tokens (JWTs). With a JSON Web Key (JWK), it verifies JWT authenticity and exposes the validated claims to SQL. Without a JWK, it can use PostgREST- compatible JWT claims for identifying the current user.

Package details

Extension version
0.5.0
Image built
Publisher
cnpg-extensions
Build
PGRX
Platform
PG 18 · Trixie · arm64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_session_jwt;
SQL version
0.5.0

PostgreSQL parameters

None specified

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Unavailable

Extension recipe
Apache-2.0

License expressions in the shipped package inventory

  • MIT OR Apache-2.033 packages
  • MIT13 packages
  • Apache-2.0 OR MIT10 packages
  • BSD-3-Clause3 packages
  • Unlicense OR MIT2 packages
  • (MIT OR Apache-2.0) AND Unicode-3.01 package
  • Apache-2.01 package
  • GPL-2.0-only AND GPL-2.0-or-later AND LicenseRef-verbatim1 package
1 more license expressions
  • Zlib1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

24 files read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_session_jwt is a PostgreSQL extension for managing authenticated sessions through JSON Web Tokens (JWTs). With a JSON Web Key (JWK), it verifies JWT authenticity and exposes the validated claims to SQL. Without a JWK, it can use PostgREST- compatible JWT claims for identifying the current user.

Package details

Extension version
0.5.0
Image built
Publisher
cnpg-extensions
Build
PGRX
Platform
PG 18 · Bookworm · amd64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_session_jwt;
SQL version
0.5.0

PostgreSQL parameters

None specified

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Unavailable

Extension recipe
Apache-2.0

License expressions in the shipped package inventory

  • MIT OR Apache-2.033 packages
  • MIT13 packages
  • Apache-2.0 OR MIT10 packages
  • BSD-3-Clause3 packages
  • Unlicense OR MIT2 packages
  • (MIT OR Apache-2.0) AND Unicode-3.01 package
  • Apache-2.01 package
  • LicenseRef-fd7e4aae7e7b05f217bcf2d02322825c360e66c52c4c2f1b28d784d6297a1c231 package
1 more license expressions
  • Zlib1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

24 files read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_session_jwt is a PostgreSQL extension for managing authenticated sessions through JSON Web Tokens (JWTs). With a JSON Web Key (JWK), it verifies JWT authenticity and exposes the validated claims to SQL. Without a JWK, it can use PostgREST- compatible JWT claims for identifying the current user.

Package details

Extension version
0.5.0
Image built
Publisher
cnpg-extensions
Build
PGRX
Platform
PG 18 · Bookworm · arm64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_session_jwt;
SQL version
0.5.0

PostgreSQL parameters

None specified

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Unavailable

Extension recipe
Apache-2.0

License expressions in the shipped package inventory

  • MIT OR Apache-2.033 packages
  • MIT13 packages
  • Apache-2.0 OR MIT10 packages
  • BSD-3-Clause3 packages
  • Unlicense OR MIT2 packages
  • (MIT OR Apache-2.0) AND Unicode-3.01 package
  • Apache-2.01 package
  • LicenseRef-fd7e4aae7e7b05f217bcf2d02322825c360e66c52c4c2f1b28d784d6297a1c231 package
1 more license expressions
  • Zlib1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

24 files read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence