RE: Psql meta-command conninfo+

  On Tue, Feb 06, 2024 at 03:06:05PM -0600, Nathan Bossart wrote:
  > 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";

  ... although that seems to be missing items like the socket directory and
  the host.

--//--

My initial idea has always been that they should continue to appear because \conninfo+ should show all the things that \conninfo shows and add more information. I think that's the purpose of the 'plus.' Now we're on a better path than the initial one. We can still add the socket directory and the host.

Regards,
Maiquel O. Grassi.