Horton

Re: Psql meta-command conninfo+

Hunaid Sohail <hunaidpgml@gmail.com>

View thread View on postgr.es
From: Hunaid Sohail <hunaidpgml@gmail.com>
To: Jim Jones <jim.jones@uni-muenster.de>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Maiquel Grassi <grassi@hotmail.com.br>, Nathan Bossart <nathandbossart@gmail.com>, "Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, Tom Lane <tgl@sss.pgh.pa.us>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-09-11T11:35:20Z
Lists: pgsql-hackers 
Hi Jim,

On Wed, Sep 11, 2024 at 3:03 PM Jim Jones <jim.jones@uni-muenster.de> wrote:

> Thanks for working on this.
>
> Any particular reason for the design change? In v28 it returned a table
> with a single row and multiple columns --- one column per attribute. But
> now it returns multiple rows. In this case, I was expecting 1 row with 7
> columns instead of 7 rows with 2 columns.
>

I am not sure which design you are referring to.
I haven't applied the v28 patch but the original author in thread [1]
provided sample output. The output is in tabular form with 2 columns and
multiple rows.

[1]
https://www.postgresql.org/message-id/CP8P284MB249615AED23882E1E185C8ABEC3C2%40CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM


Regards,
Hunaid Sohail

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.