>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.
