Horton

Re: Psql meta-command conninfo+

Sami Imseih <samimseih@gmail.com>

View thread View on postgr.es
From: Sami Imseih <samimseih@gmail.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Maiquel Grassi <grassi@hotmail.com.br>, Hunaid Sohail <hunaidpgml@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Jim Jones <jim.jones@uni-muenster.de>, Tom Lane <tgl@sss.pgh.pa.us>, Nathan Bossart <nathandbossart@gmail.com>, "Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>, "David G. Johnston" <david.g.johnston@gmail.com>
Date: 2025-01-09T19:27:51Z
Lists: pgsql-hackers 
> v35 seems fine to me from a UI standpoint; I suggest we move forward
> with that.

I am also OK with moving forward with a single \conninfo+, but
I think we should include all parameters in [1] as part of the output.
These are the parameters the server reports back to the client. I think
they are all useful to report in this command.

Also, we should also make "role" a part of the PQparameterStatus
list. This is because is_superuser can change when either
"session authorization" or "role" changes. See [2]

[1] https://www.postgresql.org/docs/current/libpq-status.html#LIBPQ-PQPARAMETERSTATUS
[2] https://www.postgresql.org/message-id/CAA5RZ0vN3RbekDNUUhD7CTFL2t7imZ2JS--aFNMHz18mr_yzNA%40mail.gmail.com

Regards,

Sami

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.