Re: Psql meta-command conninfo+

Dean Rasheed <dean.a.rasheed@gmail.com>

From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Hunaid Sohail <hunaidpgml@gmail.com>, Sami Imseih <samimseih@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, Maiquel Grassi <grassi@hotmail.com.br>, "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>
Date: 2025-01-14T09:50:51Z
Lists: pgsql-hackers
On Tue, 14 Jan 2025 at 08:51, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> On 2025-Jan-14, Hunaid Sohail wrote:
>
> > I've tried the approach and attached the output.  Does this look good?
>
> Hmm, I'm not sure I like the third column particularly; it's noisy to
> have on all the time.  I'd leave that for \conninfo++ maybe :-)
>

Yeah, I thought perhaps it might provide some useful extra
information, however...

> _If_ we keep the descriptions, I suggest that the majority need to be
> very short, say three words tops, with exceptions allowed for egregious
> cases (if any).  We should get rid of filler words such as "Displays
> the" or "Indicates whether".  For instance, I'd turn "Indicates if
> GSSAPI authentication was used for the connection" into "GSSAPI
> authenticated?" which conveys exactly the same; the ending "?" matches
> things like "Key?" in \d of an index or the "Default?" column in \dc.
> It's a boolean, so people know how to read it.
>

By the time the filler words have been stripped out, the description
isn't really adding any useful information that can't be guessed from
the parameter name and value. So I tend to agree that it should be
left out (for now at least).

Regards,
Dean



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.