.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 '[NULL]'

-- 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 > '

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

-- Use best available output format
\x auto
\set VERBOSITY verbose
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\set COMP_KEYWORD_CASE upper
\unset QUIET

-- psql can't check for a file's existence, so we'll provide an empty local
-- file that users can override with their custom dotfiles. To set your own
-- personal settings, place your own file in ~/.psqlrc.local
\i ~/.psqlrc.local



-- \set QUIET 1
-- \pset null '[NULL]'
-- 
-- -- Customize prompts
-- \set PROMPT1 '%[%033[1;34m%]psql(%[%033[1;31m%]%n%[%033[1;35m%]@%[%033[1;31m%]%/%[%033[1;34m%])%[%033[1;33m%]%R%#%x %[%033[0m%]'
-- \set PROMPT2 '%[%033[1;34m%]psql(%[%033[1;31m%]%n%[%033[1;35m%]@%[%033[1;31m%]%/%[%033[1;34m%])%[%033[1;33m%]%R%#%x %[%033[0m%]'
-- 
-- -- Show how long each query takes to execute
-- \timing
-- 
-- -- Use best available output format
-- \x auto
-- \set VERBOSITY verbose
-- \set HISTFILE ~/.psql_history- :DBNAME
-- \set HISTCONTROL ignoredups
-- \set COMP_KEYWORD_CASE upper
-- \unset QUIET