Horton

RE: Psql meta-command conninfo+

Maiquel Grassi <grassi@hotmail.com.br>

View thread View on postgr.es
From: Maiquel Grassi <grassi@hotmail.com.br>
To: "Imseih (AWS), Sami" <simseih@amazon.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Nathan Bossart <nathandbossart@gmail.com>, Jim Jones <jim.jones@uni-muenster.de>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-04-04T14:57:46Z
Lists: pgsql-hackers

Attachments

Hi folks,

(v28)

I made a modification to a variable in the 'host' column in the archive 'describe.c'.

Test:

[postgres@localhost ~]$ /home/pgsql-17devel/bin/psql -x -p 5432
psql (17devel, server 15.6)
Type "help" for help.

postgres=# \conninfo
You are connected to database "postgres" as user "postgres" via socket in "/tmp" at port "5432".
postgres=# \conninfo+
Current Connection Information
-[ RECORD 1 ]----------------+---------
Database                     | postgres
Authenticated User           | postgres
Socket Directory             | /tmp
Host                         |
Server Port                  | 5432
Server Address               |
Client Address               |
Client Port                  |
Backend PID                  | 26728
System User                  |
Current User                 | postgres
Session User                 | postgres
Application Name             | psql
SSL Connection               | f
SSL Protocol                 |
SSL Cipher                   |
SSL Compression              |
GSSAPI Authenticated         | f
GSSAPI Principal             |
GSSAPI Encrypted             | f
GSSAPI Credentials Delegated |

postgres=# \q
[postgres@localhost ~]$ /home/pgsql-17devel/bin/psql -x -p 5000
psql (17devel)
Type "help" for help.

postgres=# \conninfo
You are connected to database "postgres" as user "postgres" via socket in "/tmp" at port "5000".
postgres=# \conninfo+
Current Connection Information
-[ RECORD 1 ]----------------+---------
Database                     | postgres
Authenticated User           | postgres
Socket Directory             | /tmp
Host                         |
Server Port                  | 5000
Server Address               |
Client Address               |
Client Port                  |
Backend PID                  | 26730
System User                  |
Current User                 | postgres
Session User                 | postgres
Application Name             | psql
SSL Connection               | f
SSL Protocol                 |
SSL Cipher                   |
SSL Compression              |
GSSAPI Authenticated         | f
GSSAPI Principal             |
GSSAPI Encrypted             | f
GSSAPI Credentials Delegated | f

Regards,
Maiquel Grassi.

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.