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: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 23 Sep 2024 14:34:39 +0200
Message-ID: <CAFCRh-88pOKE=ybmar4x-R86JArimnhLbFryXmYVWOq6fn6Qwg@mail.gmail.com>
Subject: Re: Customize psql prompt to show current_role
To: Asad Ali <asadalinagri@gmail.com>
Cc: 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-88pOKE%3Dybmar4x-R86JArimnhLbFryXmYVWOq6fn6Qwg%40mail.gmail.com>
Precedence: bulk

On Mon, Sep 23, 2024 at 2:22=E2=80=AFPM Asad Ali <asadalinagri@gmail.com> w=
rote:
> There is no direct prompt escape sequence like %n for displaying the curr=
ent_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.

Hi Ali. Doesn't seem to be working for me. Did I do something wrong? --DD

```
D:\>psql service=3Dpau16
psql (17beta3, server 16.1)
Type "help" for help.

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>
```