Horton

Re: Psql meta-command conninfo+

Sami Imseih <samimseih@gmail.com>

View thread View on postgr.es
From: Sami Imseih <samimseih@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Maiquel Grassi <grassi@hotmail.com.br>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Hunaid Sohail <hunaidpgml@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, "David G. Johnston" <david.g.johnston@gmail.com>, Jim Jones <jim.jones@uni-muenster.de>, 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>, Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-02-21T23:30:06Z
Lists: pgsql-hackers 
> If we want to include 'role' in this output, what I'd propose is to
> have \conninfo issue "SHOW role", which is accepted by every server
> version.  If it fails (say because we're in an aborted transaction),
> just omit that row from the output.

v37- would have handled this as the list of PQ parameters was
dynamically generated and only those parameters
reported by the specific version of the server showed up in
\conninfo+.

Of course that may have led to confusion in which some versions
show role while others did not, but that could be dealt with in
documentation.

--

Sami Imseih
Amazon Web Services (AWS)

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.