psql: add vim modeline

[config/dotfiles.git] / psql / psqlrc.in

diff --git a/psql/psqlrc.in b/psql/psqlrc.in
index ad37eaced6d8c98880030f2591f2820318cb9865..23cc2d94354312763ccfdcc74f5bd46929868c95 100644 (file)
--- a/psql/psqlrc.in
+++ b/psql/psqlrc.in
@@ -34,21 +34,19 @@
 -- restart the transaction on a typo in a statement.
 \set ON_ERROR_ROLLBACK interactive
 
--- Uppercase keywords when completing. Thanks to [1] (read on 2016-08-06).
--- [1]: http://phili.pe/posts/postgresql-on-the-command-line/
-\set COMP_KEYWORD_CASE upper
-
 -- "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%# '
+-- 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%# '
 
 -- But display the normal psql welcome message.
 \set QUIET off
+
+-- vim: ft=sql