Date: Mon, 23 Sep 2024 14:49:15 +0200 (CEST)
From: gparc@free.fr
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Asad Ali <asadalinagri@gmail.com>, pgsql-general@postgresql.org
Message-ID: <2094959968.511571297.1727095755371.JavaMail.zimbra@free.fr>
In-Reply-To: <CAFCRh-88pOKE=ybmar4x-R86JArimnhLbFryXmYVWOq6fn6Qwg@mail.gmail.com>
References: <CAFCRh-_VwScttZi4R8grSd-b=7qguAnSzXp_+jbdpUkp=TfxPQ@mail.gmail.com> <CAJ9xe=ttSfESR=z2YZycow8DubyfQeOgOzMDUCE95f2vN-TzFg@mail.gmail.com> <CAFCRh-88pOKE=ybmar4x-R86JArimnhLbFryXmYVWOq6fn6Qwg@mail.gmail.com>
Subject: Re: Customize psql prompt to show current_role
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Thread-Topic: Customize psql prompt to show current_role
Thread-Index: at4XAuOMtwOgm9xkdNQMchK5r9WVoQ==
Archived-At: <https://www.postgresql.org/message-id/2094959968.511571297.1727095755371.JavaMail.zimbra%40free.fr>
Precedence: bulk

----- Mail original -----
> De: "Dominique Devienne" <ddevienne@gmail.com>
> =C3=80: "Asad Ali" <asadalinagri@gmail.com>
> Cc: pgsql-general@postgresql.org
> Envoy=C3=A9: Lundi 23 Septembre 2024 14:34:39
> Objet: Re: Customize psql prompt to show current_role

> On Mon, Sep 23, 2024 at 2:22=E2=80=AFPM Asad Ali <asadalinagri@gmail.com>=
 wrote:
>> 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 cu=
stom
>> prompt that includes the result of current_role.
>=20
> Hi Ali. Doesn't seem to be working for me. Did I do something wrong? --DD
>=20
> ```
> D:\>psql service=3Dpau16
> psql (17beta3, server 16.1)
> Type "help" for help.
>=20
> ddevienne=3D> \set current_role 'SELECT current_role;'
> ddevienne=3D> \set PROMPT1 '%n@%/ (%`current_role`)=3D%# '
> 'current_role' is not recognized as an internal or external command,
> operable program or batch file.
> ddevienne@ddevienne ()=3D> select 1;
> ...
> 'current_role' is not recognized as an internal or external command,
> operable program or batch file.
> ddevienne@ddevienne ()=3D>
> ```

Hello Dominique,

I will use psql \gset command for this

Regards
Gilles