Re: session username in default psql prompt?

On Mon, 25 Mar 2024 at 11:40, jian he <jian.universality@gmail.com> wrote:
> transaction related information lost.

Ah yeah, it seems I somehow lost the %x
How about:
\set PROMPT1 '%n@%~\n%R%x%# '

Or maybe even this more verbose one, which closely matches the
postgresql:// connection string format:

\set PROMPT1 '%n@%M:%>/%/\n%R%x%# '

or even add in some bold/colors like this, to make the prompt stand
out from a query:

\set PROMPT1 '%[%033[1m%]%n@%M:%>/%/\n%R%x%#%[%033[0m%] '