MIME-Version: 1.0
References: <CAFCRh-_VwScttZi4R8grSd-b=7qguAnSzXp_+jbdpUkp=TfxPQ@mail.gmail.com>
 <CAJ9xe=ttSfESR=z2YZycow8DubyfQeOgOzMDUCE95f2vN-TzFg@mail.gmail.com>
 <ac0884a4-daee-465e-bc82-8e3585998053@ewie.name> <CAFCRh--uBYcJ0gyBakSAzby0CmM2gvjo4Wa9OF79Od+-PXQP0A@mail.gmail.com>
 <f65faa53285ca29541356809ee1c49b7ed04a33a.camel@cybertec.at>
 <3079980.1727103295@sss.pgh.pa.us> <CAFCRh--cXUafqTO8eANpQh2Bve+1o7YtWSC1+F8aQ9rvA+MbUA@mail.gmail.com>
 <c2456af3-bafb-407a-8616-13f760b5fcab@aklaver.com>
In-Reply-To: <c2456af3-bafb-407a-8616-13f760b5fcab@aklaver.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 23 Sep 2024 17:37:58 +0200
Message-ID: <CAFCRh-8=zWRpDXiVUUqtFN5F=xhYUqqtieA8Hg0NiCxqe+sESQ@mail.gmail.com>
Subject: Re: Customize psql prompt to show current_role
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, 
	Erik Wienhold <ewie@ewie.name>, Asad Ali <asadalinagri@gmail.com>, pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-8%3DzWRpDXiVUUqtFN5F%3DxhYUqqtieA8Hg0NiCxqe%2BsESQ%40mail.gmail.com>
Precedence: bulk

On Mon, Sep 23, 2024 at 5:16=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com> wrote:
> On 9/23/24 08:07, Dominique Devienne wrote:
> > I often resort to \conninfo, but it's less automatic and
> > harder to visually parse (IMHO) compared to a custom ad-hoc prompt.

> For me that shows the user that connected(session_user) not the current_u=
ser.

yeah, sure, I realized that just after sending my last post...
I resort to using both \conninfo *and* `select current_role`.
I used \conninfo to tell me which server I'm on (since not
on the default prompt, before I played with it today), which
session_user I'm connected with (ddevienne or dd_login
in my recent example), and finally `select current_role`
which matters in my use-cases (session_user or dd_admin or dd_user).

I'd like not to have to type those commands/queries all the time,
and have them in the prompt at all time. I get that it's not for everyone,
nor even necessary all the time, but I sincerely think it is definitely use=
ful.

I'd be glad to use Pavel's proposed %N. --DD