↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / psql Commands

\getenv

Gets the value of the environment variable env_var and assigns it to the psql variable psql_var . If env_var is not defined in the psql process's environment, psql_var is not changed. Example:

Reading PG 18·Select a recorded version

Client
psql 18.7
Case-sensitive spelling
\getenv
command
\getenv
manual path
app-psql.html#APP-PSQL-META-COMMAND-GETENV
modifiers
Unknown
signature
\getenv psql_var env_var
spellings
\getenv

Definition PG 18

\getenv psql_var env_var

Gets the value of the environment variable env_var and assigns it to the psql variable psql_var. If env_var is not defined in the psql process's environment, psql_var is not changed. Example:

=> \getenv home HOME
=> \echo :home
/home/postgres

Exact case-sensitive spellings

  • \getenv

Spellings in this manual definition

CommandDocumented suffix modifiers
\getenvNone listed in this signature

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915

Text language: en · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915