From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
cc: Dominique Devienne <ddevienne@gmail.com>,
        Laurenz Albe <laurenz.albe@cybertec.at>,
        Erik Wienhold <ewie@ewie.name>, Asad Ali <asadalinagri@gmail.com>,
        pgsql-general@postgresql.org
Subject: Re: Customize psql prompt to show current_role
In-reply-to: <c2456af3-bafb-407a-8616-13f760b5fcab@aklaver.com>
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>
Comments: In-reply-to Adrian Klaver <adrian.klaver@aklaver.com>
	message dated "Mon, 23 Sep 2024 08:16:53 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3085359.1727105807.1@sss.pgh.pa.us>
Date: Mon, 23 Sep 2024 11:36:47 -0400
Message-ID: <3085360.1727105807@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3085360.1727105807%40sss.pgh.pa.us>
Precedence: bulk

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> 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_user.

Worse than that: what it reports is libpq's PQuser(), that is the
name that was used to log in with.  But if what you want is the
session_user, psql prompts already have %n for that.

			regards, tom lane