Wiki / psql Commands / Connections and sessions
\conninfo
Outputs information about the current database connection, including SSL-related information if SSL is in use.
Reading PostgreSQL 18.6.
Description
Outputs information about the current database connection, including SSL-related information if SSL is in use.
- Client
- psql 18.6
- Case-sensitive spelling
- \conninfo
Usage
\conninfoSpellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \conninfo | None listed in this signature |
Manual definition
\conninfo-
Outputs information about the current database connection, including SSL-related information if SSL is in use.
Note that the
Client Userfield shows the user at the time of connection, while theSuperuserfield 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 theSET ROLEcommand.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: changed.
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,5 +1,5 @@
{
- "definition": "Outputs information about the current database connection.",
+ "definition": "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.",
"modifiers": [],
"signature": "\\conninfo",
"spellings": [Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.