psqlrc

-- Remove this:
--    Null display is "[NULL]".
--    Expanded display is used automatically.
--    psql (9.3.1)
--    Type "help" for help.
\set QUIET 1
\pset null '[NULL]'
\timing

-- Pretty lines and borders around result tables
-- http://okbob.blogspot.com/2014/10/styles-for-unicode-borders-are-merged.html
\pset border 2
\pset linestyle unicode
\pset unicode_header_linestyle double
\pset unicode_column_linestyle double

-- http://www.postgresql.org/docs/9.3/static/app-psql.html#APP-PSQL-PROMPTING

\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# '
-- PROMPT2 is printed when the prompt expects more input, like when you type
-- SELECT * FROM<enter>. %R shows what type of input it expects.
\set PROMPT2 '[more] %R > '

-- Use best available output format
\x auto

\set VERBOSITY verbose
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\set COMP_KEYWORD_CASE upper

\setenv PAGER 'pspg --no-mouse -X -s5'
\unset quiet