Date: Thu, 8 Feb 2024 20:41:55 -0600
From: Nathan Bossart <nathandbossart@gmail.com>
To: Maiquel Grassi <grassi@hotmail.com.br>
Cc: Jim Jones <jim.jones@uni-muenster.de>, Erik Wienhold <ewie@ewie.name>,
	Pavel Luzanov <p.luzanov@postgrespro.ru>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Psql meta-command conninfo+
Message-ID: <20240209024155.GA659389@nathanxps13>
References: <852cabef-f596-4826-9a54-d3f75d9a6cc8@postgrespro.ru>
 <CP8P284MB24961361A9C1D32C28A7EC0EEC452@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
 <e289dada-543d-495f-9cd3-5783a8412bc0@postgrespro.ru>
 <CP4P284MB24830F5BF17FFA7F3D733142EC452@CP4P284MB2483.BRAP284.PROD.OUTLOOK.COM>
 <47dcfd6f-d1d8-4a13-9bc5-b43ee9bd534f@uni-muenster.de>
 <CP8P284MB2496D053FD15C80780B72F46EC442@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
 <cefe290e-4e70-4cfd-89e9-888e916f6b51@uni-muenster.de>
 <gdgfqn2kuxp6w635bzz35me45a5zsswdcmqciuylui5dxxgmmd@par2aijoq4jw>
 <d6f8d07c-ea89-4e91-b263-34d6b2123c8f@uni-muenster.de>
 <CP8P284MB2496BA609AD64698B5550A58EC4B2@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CP8P284MB2496BA609AD64698B5550A58EC4B2@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM>
Archived-At: <https://www.postgresql.org/message-id/20240209024155.GA659389%40nathanxps13>
Precedence: bulk

Sorry if this has been brought up, but I noticed that some of the
information is listed below the result set:

	postgres=# \conninfo+
	Current Connection Information
	-[ RECORD 1 ]------+---------
	Database           | postgres
	Authenticated User | nathan
	System User        | 
	Current User       | nathan
	Session User       | nathan
	Session PID        | 659410
	Server Version     | 17devel
	Server Address     | ::1
	Server Port        | 5432
	Client Address     | ::1
	Client Port        | 59886
	Socket Directory   | 
	Host               | ::1

	SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)

Shouldn't we move this information into the result set?  Separately, does
the server version really belong here?  I'm not sure I would consider that
to be connection information.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com