Content-Type: multipart/alternative;
 boundary="------------Ki6ugLIXDlq8riyApUcpjgWJ"
Message-ID: <852cabef-f596-4826-9a54-d3f75d9a6cc8@postgrespro.ru>
Date: Wed, 7 Feb 2024 15:35:34 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Psql meta-command conninfo+
Content-Language: en-US, ru-RU
To: Maiquel Grassi <grassi@hotmail.com.br>,
 Nathan Bossart <nathandbossart@gmail.com>
Cc: Erik Wienhold <ewie@ewie.name>,
 "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
References: <CP8P284MB24965CB63DAC00FC0EA4A475EC462@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
 <20240206181919.GA3853632@nathanxps13>
 <aevq2dxmw2xm2rc3nh2wdcozunipco447mf4rpm7efvqvz4wk2@mo3zmf2ulbzu>
 <CP8P284MB2496B51FC5ED9BD6527D459DEC462@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
 <20240206210605.GA3903769@nathanxps13> <20240206211205.GA3903996@nathanxps13>
 <CP8P284MB24965479BA59DF5C2CC01CA0EC462@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
 <20240206215022.GA3452@nathanxps13>
 <CP8P284MB2496A17A9852265A0F363A6AEC452@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: <CP8P284MB2496A17A9852265A0F363A6AEC452@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
Archived-At: <https://www.postgresql.org/message-id/852cabef-f596-4826-9a54-d3f75d9a6cc8%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Ki6ugLIXDlq8riyApUcpjgWJ
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

This is a good idea about extended connection info.

On 07.02.2024 07:13, Maiquel Grassi wrote:
> 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

--------------Ki6ugLIXDlq8riyApUcpjgWJ
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <pre>This is a good idea about extended connection info.

</pre>
    On 07.02.2024 07:13, Maiquel Grassi wrote:<br>
    <blockquote type="cite"
cite="mid:CP8P284MB2496A17A9852265A0F363A6AEC452@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style><span
style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">SELECT</span>
      <div class="elementToProof"><span
style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">...<br>
        </span></div>
      <div><span
style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);"> 
          current_user AS "User",</span></div>
    </blockquote>
    <pre>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.
</pre>
    <pre class="moz-signature" cols="72">-- 
Pavel Luzanov
Postgres Professional: <a class="moz-txt-link-freetext" href="https://postgrespro.com">https://postgrespro.com</a></pre>
  </body>
</html>

--------------Ki6ugLIXDlq8riyApUcpjgWJ--