| From: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> |
|---|---|
| To: | Hunaid Sohail <hunaidpgml(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | 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-11 10:03:05 |
| Message-ID: | 7707a01b-a324-44a4-865a-a238a5da3a4d@uni-muenster.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11.09.24 10:16, Hunaid Sohail wrote:
> I have made the requested changes. Now output is returned in tabular
> form. Indentation/whitespace issues are fixed.
>
> $bin/psql --port=5430 postgres
> postgres=# \conninfo+
> You are connected to database "postgres" as user "hunaid" via socket
> in "/tmp" at port "5430".
> Connection Information
> Parameter | Value
> ----------------------+--------
> Protocol Version | 3
> SSL Connection | no
> GSSAPI Authenticated | no
> Client Encoding | UTF8
> Server Encoding | UTF8
> Session User | hunaid
> Backend PID | 121800
> (7 rows)
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.
Jim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2024-09-11 10:03:53 | Re: PG_TEST_EXTRA and meson |
| Previous Message | Peter Eisentraut | 2024-09-11 09:57:14 | Re: json_query conditional wrapper bug |