.psqlrc

-- almost entirely copied from https://git.io/vxeUB. Thanks, @mitsuhiko!

-- disable output temporarily
\set QUIET on

-- nicer rendering for null
\pset null ¤

-- nicer tables
\pset linestyle unicode

-- enable timers
\timing on

-- disable default pager
\pset pager off

-- automatically switch to \x for large outputs
\x auto

-- nicer prompt
\set PROMPT1 '\n%[%033[0;33;35m%]%n%[%033[0m%]@%[%033[0;33;33m%]%M%[%033[0m%]/%[%033[0;33;32m%]%/%[%033[0m%] %[%033[0;33;36m%]%x%[%033[0m%]\n%R%[%033[0;33;36m%]>%[%033[0m%] '
\set PROMPT2 '%R%[%033[0;33;36m%]>%[%033[0m%] '

-- better errors
\set VERBOSITY verbose

-- keep history per database
\set HISTFILE ~/.cache/psql-history- :DBNAME

-- keep infinite history
\set HISTSIZE -1

-- keep inputs in the history once
\set HISTCONTROL ignoredups

-- always auto complete in lowercase
\set COMP_KEYWORD_CASE lower

-- output back on
\set QUIET off

-- complete keywords to lowercase
\set COMP_KEYWORD_CASE lower