Re: Psql meta-command conninfo+

Alvaro Herrera <alvherre@alvh.no-ip.org>

From: Alvaro Herrera <alvherre@alvh.no-ip.org>

To: Maiquel Grassi <grassi@hotmail.com.br>

Cc: Erik Wienhold <ewie@ewie.name>, Jim Jones <jim.jones@uni-muenster.de>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Nathan Bossart <nathandbossart@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2024-02-09T10:19:03Z

Lists: pgsql-hackers

Hmm, I noticed that this would call printSSLInfo() and printGSSInfo()
after listConnectionInformation.  It would be much better to show these
in tabular format as well and remove the calls to printSSL/GSSInfo.

I propose additional columns to the same \conninfo+ table; when SSL,
like this:

Database           | postgres
[...]
Host               | 127.0.0.1
Encryption         | SSL
Protocol           | PQsslAttribute(protocol)
Cipher             | PQsslAttribute(cipher)
Compression        | PQsslAttribute(compression)

When GSS, like this

Database           | postgres
[...]
Host               | 127.0.0.1
Encryption         | GSS

(why don't we print anything else in printGSSInfo()?  That's weird.)

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)

Commits

psql: Change new \conninfo to use SSL instead of TLS
- 6d6480066c1a 18.0 landed
Change \conninfo to use tabular format
- bba2fbc6238b 18.0 landed
Update extension lookup routines to use the syscache
- d8df7ac5c04c 18.0 cited
Improve COPY TO performance when server and client encodings match
- b619852086ed 17.0 cited
doc: Remove superfluous bracket in synopsis
- fdfb92c0307c 17.0 cited
Remove psql support for server versions preceding 9.2.
- cf0cab868aa4 15.0 cited