Horton

Re: Psql meta-command conninfo+

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Sami Imseih <samimseih@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-09T19:35:00Z
Lists: pgsql-hackers 
On Thu, Jan 9, 2025 at 12:28 PM Sami Imseih <samimseih@gmail.com> wrote:

> > 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.
>

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 ?

This also makes the non-expanded output, the default, the readable one.

David J.

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.