↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / psql Commands

\conninfo

Outputs information about the current database connection, including SSL-related information if SSL is in use.

Reading PG 18·Select a recorded version

Client
psql 18.7
Case-sensitive spelling
\conninfo
command
\conninfo
manual path
app-psql.html#APP-PSQL-META-COMMAND-CONNINFO
modifiers
Unknown
signature
\conninfo
spellings
\conninfo

Definition PG 18

\conninfo

Outputs information about the current database connection, including SSL-related information if SSL is in use.

Note that the Client User field shows the user at the time of connection, while the Superuser field indicates whether the current user (in the current execution context) has superuser privileges. These users are usually the same, but they can differ, for example, if the current user was changed with the SET ROLE command.

Exact case-sensitive spellings

  • \conninfo

Spellings in this manual definition

CommandDocumented suffix modifiers
\conninfoNone 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