Suggestions for improving \conninfo output in v18
Fujii Masao <masao.fujii@oss.nttdata.com>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: pgsql-hackers@postgresql.org
Date: 2025-06-02T04:48:25Z
Lists: pgsql-hackers
Hi, In v18, the "Protocol Version" column shown by \conninfo reports only the major version (e.g., 3). Wouldn't it be more helpful to show the full version (e.g., 3.2) using PQfullProtocolVersion()? Since support for protocol version 3.2 was introduced in v18, users may want to know exactly which version the current session is using. Also, I noticed that the "Client User" column reflects the user at the time of connection, while the "Superuser" column reflects whether the current user in the current execution context is a superuser. This means the users referred to in these columns can differ. It might be worth aligning this behavior, or at least noting the distinction clearly in the documentation? Regards, -- Fujii Masao NTT DATA Japan Corporation
Commits
-
doc: Add note about "Client User" and "Superuser" fields in \conninfo output.
- 0fe50417eca4 18.0 landed
-
psql: Report full protocol version in \conninfo output.
- be37ac20fc23 18.0 landed
-
Change \conninfo to use tabular format
- bba2fbc6238b 18.0 cited