Feedback-ID: ia2694551:Fastmail
Date: Sat, 14 Sep 2024 19:37:11 +0200
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Hunaid Sohail <hunaidpgml@gmail.com>
Cc: Jim Jones <jim.jones@uni-muenster.de>, 
	Maiquel Grassi <grassi@hotmail.com.br>, Nathan Bossart <nathandbossart@gmail.com>, 
	"Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, 
	Tom Lane <tgl@sss.pgh.pa.us>, Pavel Luzanov <p.luzanov@postgrespro.ru>, 
	Erik Wienhold <ewie@ewie.name>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Psql meta-command conninfo+
Message-ID: <202409141737.kordblqr6tjv@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAMWA6ybETGLZ6XdRvPYwme_ByyrXze-NzopHvum0ZHgCgpBL+w@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/202409141737.kordblqr6tjv%40alvherre.pgsql>
Precedence: bulk

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)