psqlrc

-- Official docs: http://www.postgresql.org/docs/9.3/static/app-psql.html
-- Unofficial docs: http://robots.thoughtbot.com/improving-the-command-line-postgres-experience

-- Don't display the "helpful" message on startup.
\set QUIET 1
\pset null ∅

-- Show how long each query takes to execute
\timing

-- Use best available output format
\x auto
\t off
\set VERBOSITY verbose
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\pset linestyle 'unicode'
\pset unicode_border_linestyle single
\pset unicode_column_linestyle single
\pset unicode_header_linestyle double
set intervalstyle to 'postgres_verbose';
\setenv LESS '-iMFXSx4R'
\setenv PAGER 'pspg --no-mouse -bX --no-commandbar --no-topbar -s 11'

-- Transactions
\set ON_ERROR_STOP on
\set ON_ERROR_ROLLBACK interactive

\unset QUIET