MIME-Version: 1.0
References: <CAFCRh-_VwScttZi4R8grSd-b=7qguAnSzXp_+jbdpUkp=TfxPQ@mail.gmail.com>
 <CAJ9xe=ttSfESR=z2YZycow8DubyfQeOgOzMDUCE95f2vN-TzFg@mail.gmail.com>
In-Reply-To: <CAJ9xe=ttSfESR=z2YZycow8DubyfQeOgOzMDUCE95f2vN-TzFg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 23 Sep 2024 09:02:57 -0400
Message-ID: <CAKAnmmLPBSErcRJmMOOdOOHUHrjopDC7Th1Un3rJtHDqH3y2nQ@mail.gmail.com>
Subject: Re: Customize psql prompt to show current_role
To: Asad Ali <asadalinagri@gmail.com>
Cc: Dominique Devienne <ddevienne@gmail.com>, pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000203d050622c9045b"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLPBSErcRJmMOOdOOHUHrjopDC7Th1Un3rJtHDqH3y2nQ%40mail.gmail.com>
Precedence: bulk

--000000000000203d050622c9045b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Sep 23, 2024 at 8:22=E2=80=AFAM Asad Ali <asadalinagri@gmail.com> w=
rote:

> There is no direct prompt escape sequence like %n for displaying the
> current_role in the psql prompt. However, you can work around this by usi=
ng
> a \set command to define a custom prompt that includes the result of
> current_role.
>

Please do not use chatgpt or other LLMs to answer questions on this mailing
list! If you had even done the bare minimum of trying your own
lazily-generated answer, you would have found it did not work.

Greg

--000000000000203d050622c9045b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Sep 23, 2024 at 8:22=E2=80=AFAM A=
sad Ali &lt;<a href=3D"mailto:asadalinagri@gmail.com">asadalinagri@gmail.co=
m</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr"><div>There is no direct prompt=
 escape sequence like %n for displaying the current_role in the psql prompt=
. However, you can work around this by using a \set command to define a cus=
tom prompt that includes the result of current_role.<br></div></div></block=
quote><div><br></div><div>Please do not use chatgpt=C2=A0or other LLMs to a=
nswer questions on this mailing list! If you had even done the bare minimum=
 of trying your own lazily-generated answer, you would have found it did no=
t work.</div><div><br></div><div>Greg</div><div><br></div></div></div>

--000000000000203d050622c9045b--