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: Hunaid Sohail <hunaidpgml@gmail.com>
Cc: Maiquel Grassi <grassi@hotmail.com.br>, Jim Jones <jim.jones@uni-muenster.de>, Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@alvh.no-ip.org>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, 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: 2024-10-07T16:30:28Z
Lists: pgsql-hackers 
On Sun, Oct 6, 2024 at 11:17 PM Hunaid Sohail <hunaidpgml@gmail.com> wrote:

>
> PQpass - no need
>

I would include this as presence/absence.

I concur on all of the rest.


>
> For PQparameterStatus, some parameters are already used.
> server_version and application_name were already discussed and removed in
> v12 and v29 respectively. Do we need other parameters?
>

Ok, I'll need to go read the reasoning for why they are deemed unneeded and
form an opinion one way or the other.


>
>> Within that framework having \conninfo[+[CSE][…]] be the command -
>> printing out only the table specified would be the behavior (specifying no
>> suffix letters prints all three) - would be an option.
>>
>
> 3 separate tables without suffix?
>

Yes, the tables need headers specific to their categories.

I do like the idea of having 4 though, placing settings into their own.
Premised on having all or most of the available parameters being on the
table.  If it only ends up being a few of them then keeping those in
the status table makes sense.

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.