Re: Psql meta-command conninfo+
Jim Jones <jim.jones@uni-muenster.de>
From: Jim Jones <jim.jones@uni-muenster.de>
To: Hunaid Sohail <hunaidpgml@gmail.com>
Cc: 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>,
Alvaro Herrera <alvherre@alvh.no-ip.org>,
Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>,
"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-09-10T16:00:51Z
Lists: pgsql-hackers
On 10.09.24 06:32, Hunaid Sohail wrote: > > I have attached a rebased patch. Thanks. Is \conninfo+ no longer supposed to return the results in tabular form? At least it wasn't the case till v28. $ /usr/local/postgres-dev/bin/psql -d postgres -h 0 -c "\conninfo+" You are connected to database "postgres" as user "jim" on host "0" (address "0.0.0.0") at port "5432". Protocol Version: 3 SSL Connection: no GSSAPI Authenticated: no Client Encoding: UTF8 Server Encoding: UTF8 Session User: jim Backend PID: 579041 $ /usr/local/postgres-dev/bin/psql -d postgres -h 127.0.0.1 -c "\conninfo+" You are connected to database "postgres" as user "jim" on host "127.0.0.1" at port "5432". Protocol Version: 3 SSL Connection: no GSSAPI Authenticated: no Client Encoding: UTF8 Server Encoding: UTF8 Session User: jim Backend PID: 579087 Sorry if I missed that in the thread. v31 has a couple of small indentation problems: /home/jim/patches/conninfo/v31-0001-Add-psql-meta-command-conninfo-plus.patch:87: indent with spaces. show_verbose = strchr(cmd, '+') ? true : false; /home/jim/patches/conninfo/v31-0001-Add-psql-meta-command-conninfo-plus.patch:106: trailing whitespace. Checking patch doc/src/sgml/ref/psql-ref.sgml... Checking patch src/bin/psql/command.c... Checking patch src/bin/psql/help.c... Applied patch doc/src/sgml/ref/psql-ref.sgml cleanly. Applied patch src/bin/psql/command.c cleanly. Applied patch src/bin/psql/help.c cleanly. warning: 2 lines add whitespace errors. -- Jim
Commits
-
psql: Change new \conninfo to use SSL instead of TLS
- 6d6480066c1a 18.0 landed
-
Change \conninfo to use tabular format
- bba2fbc6238b 18.0 landed
-
Update extension lookup routines to use the syscache
- d8df7ac5c04c 18.0 cited
-
Improve COPY TO performance when server and client encodings match
- b619852086ed 17.0 cited
-
doc: Remove superfluous bracket in synopsis
- fdfb92c0307c 17.0 cited
-
Remove psql support for server versions preceding 9.2.
- cf0cab868aa4 15.0 cited