Re: Psql meta-command conninfo+

Sami Imseih <samimseih@gmail.com>

From: Sami Imseih <samimseih@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, 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>
Date: 2025-01-09T20:45:55Z
Lists: pgsql-hackers
> I dislike totally discarding the category information we have available to us.  How about making a long output with just three columns in non-expanded mode.  Setting, Value, Category ?

We can probably make due without a category as
the name of the setting is informative enough, right?

If we go with the 3 column format, then we will just
have a bunch of repeated values for Category, which
looks cluttered, IMO.

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.