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%] '
