Re: Psql meta-command conninfo+ - Mailing list pgsql-hackers

From Pavel Luzanov
Subject Re: Psql meta-command conninfo+
Date
Msg-id 852cabef-f596-4826-9a54-d3f75d9a6cc8@postgrespro.ru
Whole thread Raw
In response to RE: Psql meta-command conninfo+  (Maiquel Grassi <grassi@hotmail.com.br>)
Responses RE: Psql meta-command conninfo+
List pgsql-hackers
This is a good idea about extended connection info.

On 07.02.2024 07:13, Maiquel Grassi wrote:
P {margin-top:0;margin-bottom:0;}SELECT
...
  current_user AS "User",
This will be inconsistent with \conninfo.
\conninfo returns authenticated user (PQuser), not the current_user.
It might be worth showing current_user, session_user, and authenticated user,
but I can't find the appropriate sql function for PQuser.

What about to include system_user function? It shows useful authentication details.

Also, it seems that the verbose parameter in the listConnectionInformation
is unnecessary.
-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com

pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Synchronizing slots from primary to standby
Next
From: Alvaro Herrera
Date:
Subject: Re: Commitfest 2024-01 first week update