select open change scope Open full search

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

Extensions / Features

pg_variables

Session-scoped variables with scalar, array, and record types

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

Overview

Packagepg_variables
Version1.2.5
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars13
Latest commit2026-02-23
Latest release2022-12-19
Catalogue updated2026-08-30

Related extensions

Required by

pgelogExtended logging via pseudo-autonomous transactions

See also

session_variableRegistration and manipulation of session variables and constants
omni_varScoped variables
pg_fsqlRecursive SQL template engine with JSONB-driven execution
pg_query_rewriteRewrite SQL statements with a PostgreSQL ProcessUtility hook