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

From Alvaro Herrera
Subject Re: Psql meta-command conninfo+
Date
Msg-id 202409141737.kordblqr6tjv@alvherre.pgsql
Whole thread Raw
In response to Re: Psql meta-command conninfo+  (Hunaid Sohail <hunaidpgml@gmail.com>)
Responses Re: Psql meta-command conninfo+
List pgsql-hackers
On 2024-Sep-14, Hunaid Sohail wrote:

> I agree that both messages should be printed together. IMO the message
> "You are connected to database..." should be printed at the top, no?
> Because it shows important info that the user may be interested to see
> first. Then we can combine the ssl message.
> 
> postgres=# \x
> Expanded display is on.
> postgres=# \conninfo+
> You are connected to database "postgres" as user "hunaid" on host
> "localhost" (address "127.0.0.1") at port "5430".
> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384,
> compression: off, ALPN: postgresql)
> Connection Information
> -[ RECORD 1 ]--------+-------
> Protocol Version     | 3
> SSL Connection       | yes
> GSSAPI Authenticated | no
> Client Encoding      | UTF8
> Server Encoding      | UTF8
> Session User         | hunaid
> Backend PID          | 109092

I don't understand why this is is printing half the information in
free-form plain text and the other half in tabular format.  All these
items that you have in the free-form text lines should be part of the
table, I think.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
#error "Operator lives in the wrong universe"
  ("Use of cookies in real-time system development", M. Gleixner, M. Mc Guire)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Obsolete comment in pg_stat_statements
Next
From: Tom Lane
Date:
Subject: Re: Psql meta-command conninfo+