Horton

Re: Psql meta-command conninfo+

Nathan Bossart <nathandbossart@gmail.com>

View thread View on postgr.es
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>
Date: 2024-02-09T02:41:55Z
Lists: pgsql-hackers 
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

Commits

  1. psql: Change new \conninfo to use SSL instead of TLS

  2. Change \conninfo to use tabular format

  3. Update extension lookup routines to use the syscache

  4. Improve COPY TO performance when server and client encodings match

  5. doc: Remove superfluous bracket in synopsis

  6. Remove psql support for server versions preceding 9.2.