On Mon, Sep 23, 2024 at 2:22 PM Asad Ali <asadalina...@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 custom > 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=pau16 psql (17beta3, server 16.1) Type "help" for help. ddevienne=> \set current_role 'SELECT current_role;' ddevienne=> \set PROMPT1 '%n@%/ (%`current_role`)=%# ' 'current_role' is not recognized as an internal or external command, operable program or batch file. ddevienne@ddevienne ()=> select 1; ... 'current_role' is not recognized as an internal or external command, operable program or batch file. ddevienne@ddevienne ()=> ```
