From a quick skim of the latest messages in this thread, it sounds like
there are a couple of folks who think \conninfo (and consequently
\conninfo+) should only report values from the libpq API. I think they
would prefer server-side information to be provided via a system view or
maybe an entirely new psql meta-command.
IIUC a new system view would more-or-less just gather information from
other system views and functions. A view would be nice because it could be
used outside psql, but I'm not sure to what extent we are comfortable
adding system views built on other system views. Something like
\sessioninfo (as proposed by Sami) would look more similar to what you have
in your latest patch, i.e., we'd teach psql about a complicated query for
gathering all this disparate information.
IMHO a good way to help move this forward is to try implementing it as a
system view so that we can compare the two approaches. I've had luck in
the past with implementing something a couple different ways to help drive
consensus.
--//--
Great Nathan, we can follow that path of the view. I leave it open for anyone in the thread who has been following from the beginning to start the development of the view. Even you, if you have the interest and time to do it. At this exact moment, I am involved in a "my baby born" project, so I am unable to stop to look into this. If someone wants to start, I would appreciate it.
Regards,
Maiquel Grassi.
