| From: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> |
|---|---|
| To: | Hunaid Sohail <hunaidpgml(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Maiquel Grassi <grassi(at)hotmail(dot)com(dot)br>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Psql meta-command conninfo+ |
| Date: | 2024-09-12 11:08:01 |
| Message-ID: | f14270a4-60fb-42ec-ab08-a9e8b730f000@uni-muenster.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11.09.24 13:35, Hunaid Sohail wrote:
> Hi Jim,
>
> On Wed, Sep 11, 2024 at 3:03 PM Jim Jones <jim(dot)jones(at)uni-muenster(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2024-09-12 11:08:15 | [PATCH] Support Int64 GUCs |
| Previous Message | Amul Sul | 2024-09-12 11:04:54 | Re: pg_verifybackup: TAR format backup verification |