Re: Psql meta-command conninfo+

On 11.09.24 13:35, Hunaid Sohail wrote:
> 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 
>
It may look like this, but it is a single record --- mind the header "-[
RECORD 1 ]----------------+---------".
psql was called in expanded mode:

> $ /home/pgsql-17devel/bin/psql -x -p 5432

"-x" or "--expanded"

Example:

$ psql postgres -xc "SELECT 'foo' col1, 'bar' col2"
-[ RECORD 1 ]
col1 | foo
col2 | bar

-- 
Jim