On Tue, Feb 06, 2024 at 08:52:09PM +0000, Maiquel Grassi wrote: > I made the adjustment in the code and updated the patch. I believe this > is the format suggested by you all. Would this be it?
I was thinking something more like
SELECT pg_catalog.current_database() AS "Database",
current_user AS "User",
pg_catalog.current_setting('server_version') AS "Server Version",
pg_catalog.inet_server_addr() AS "Server Address",
pg_catalog.current_setting('port') AS "Port",
pg_catalog.inet_client_addr() AS "Client Address",
pg_catalog.inet_client_port() AS "Client Port",
pg_catalog.pg_backend_pid() AS "Session PID";
--//--
Good, I had misunderstood. I liked this adjustment. Now it truly aligns with
the central idea of the other extended meta-commands.
[postgres@localhost bin]$ ./psql -h 192.168.0.220 -p 5433 -U postgres -d
postgres
psql (17devel, server 16.1)
Type "help" for help.
postgres=# \conninfo+
Current Connection Information
Database | User | Server Version | Server Address | Port | Client Address
| Client Port | Session PID
----------+----------+----------------+----------------+------+----------------+-------------+-------------
postgres | postgres | 16.1 | 192.168.0.220 | 5433 | 192.168.0.220
| 57112 | 22120
(1 row)
postgres=# \q
[postgres@localhost bin]$ ./psql
psql (17devel)
Type "help" for help.
postgres=# \conninfo+
Current Connection Information
Database | User | Server Version | Server Address | Port | Client Address
| Client Port | Session PID
----------+----------+----------------+----------------+------+----------------+-------------+-------------
postgres | postgres | 17devel | | 5432 |
| | 31430
(1 row)
postgres=# \q
[postgres@localhost bin]$ ./psql -h localhost
psql (17devel)
Type "help" for help.
postgres=# \conninfo+
Current Connection Information
Database | User | Server Version | Server Address | Port | Client Address
| Client Port | Session PID
----------+----------+----------------+----------------+------+----------------+-------------+-------------
postgres | postgres | 17devel | ::1 | 5432 | ::1
| 46918 | 31433
(1 row)
postgres=# \q
[postgres@localhost bin]$ ./psql -h 127.0.0.1
psql (17devel)
Type "help" for help.
postgres=# \conninfo+
Current Connection Information
Database | User | Server Version | Server Address | Port | Client Address
| Client Port | Session PID
----------+----------+----------------+----------------+------+----------------+-------------+-------------
postgres | postgres | 17devel | 127.0.0.1 | 5432 | 127.0.0.1
| 34970 | 31435
(1 row)
Regards,
Maiquel O. Grassi.
v3-0001-psql-meta-command-conninfo-plus.patch
Description: v3-0001-psql-meta-command-conninfo-plus.patch
