On Mon, Sep 23, 2024 at 4:55 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Laurenz Albe <laurenz.albe@xxxxxxxxxxx> writes: > > To get the current role, psql would have to query the database whenever > > it displays the prompt. That would be rather expensive... > > See previous discussion: > https://www.postgresql.org/message-id/flat/CAFj8pRBFU-WzzQhNrwRHn67N0Ug8a9-0-9BOo69PPtcHiBDQMA%40mail.gmail.com > > At the time I didn't like the idea too much, but now that we've seen > a second independent request, maybe our opinion of its value should > go up a notch. Thanks for the reference Tom. I don't follow -hackers, so missed it. Obviously I disagree with your "it's not useful enough" comment :) I often lose track of which ROLE is active, in my many long-lived psql sessions, on various servers (mainly v14 and v16 these days), especially during my recent struggle to adapt our system to v16. I often resort to \conninfo, but it's less automatic and harder to visually parse (IMHO) compared to a custom ad-hoc prompt. Therefore I want to respectfully re-iterate my interest in this enhancement. Thanks, --DD
