On Mon, 25 Mar 2024 at 11:40, jian he <jian.universal...@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%] '