-- "ignorespace ignoredups"
\set HISTCONTROL ignoreboth
-- Set path to history file and increase it.
\set HISTFILE HISTFILE_PATH
\set HISTSIZE 100000
-- "ignorespace ignoredups"
\set HISTCONTROL ignoreboth
-- Set path to history file and increase it.
\set HISTFILE HISTFILE_PATH
\set HISTSIZE 100000
--- Add transaction status (%x) to prompt.
-\set PROMPT1 '%x%/%R%# '
-\set PROMPT2 :PROMPT1
+-- Add transaction status (%x) to prompt; show database name in bold green.
+\set PROMPT1 '%x%[%033[01;32m%]%/%[%033[00m%]%R%# '
+-- Remove database from second prompt to make it easily distinguishable from
+-- PROMPT1.
+\set PROMPT2 '%x%R%# '