From: Simon Ruderich <simon@ruderich.org>
Date: Wed, 5 Jul 2017 07:50:23 +0000 (+0200)
Subject: psql: add transaction status to prompt
X-Git-Url: https://ruderich.org/simon/gitweb/?p=config%2Fdotfiles.git;a=commitdiff_plain;h=09aedd869ed40adcafe1640c01ddf5252f666aa7

psql: add transaction status to prompt
---

diff --git a/psql/psqlrc.in b/psql/psqlrc.in
index 8901fbf..8396dfd 100644
--- a/psql/psqlrc.in
+++ b/psql/psqlrc.in
@@ -39,5 +39,9 @@
 \set HISTFILE HISTFILE_PATH
 \set HISTSIZE 100000
 
+-- Add transaction status (%x) to prompt.
+\set PROMPT1 '%x%/%R%# '
+\set PROMPT2 :PROMPT1
+
 -- But display the normal psql welcome message.
 \set QUIET off