Magnus Hagander <magnus@hagander.net> writes:
> 2010/1/27 Martin Atukunda <matlads@gmail.com>:
>> How about using the psql prompt to convey this information?
> I think the idea is that if you do that, it'll be there all the time,
> potentially "crowding the space".
I had the same reaction as Martin. If you want this info all the time,
setting the prompt is the way to go. If you only want it occasionally,
you're probably more likely to remember other ways of getting the info
first (session_user, pg_stat_activity, etc etc). There may be some
use-case in between where another backslash command would be helpful,
but it seems a tad marginal to me. I don't object as long as it's not
overdesigned, but let's keep the bells and whistles to a minimum.
regards, tom lane