.psqlrc

-- Docs: https://wiki.postgresql.org/wiki/Psqlrc

-- Set prompt
-- \set PROMPT1 '%[%033[1;31;40m%]# %[%033[32m%]%n%[%033[34m%]@%[%033[36m%]%`hostname`:%>%[%033[33m%]/%/%[%033[K%]%[%033[0m%]%[%033[1;31m%]% $>%[%033[0m% '
-- \set PROMPT2 '%[%033[1;31;40m%]# %[%033[34m%]%[[more]%[%033[1;31;40m%]% $>%[%033[0m% '

\set PROMPT1 '%[%033[1;31m%]%[%033[32m%]psql:%[%033[36m%]//%n%[%033[34m%]@%[%033[36m%]%M:%>%[%033[33m%]/%/ %[%033[K%]%[%033[0m%]\n%[%033[1;33m%]%#%[%033[0m%] '
\set PROMPT2 ''

-- Display query times
\timing

-- Rest taken from here:
-- http://robots.thoughtbot.com/improving-the-command-line-postgres-experience
-- By default, NULL displays as an empty space. Is it actually an empty
-- string, or is it null? This makes that distinction visible.
\pset null '[NULL]'

-- Use table format (with headers across the top) by default, but switch to
-- expanded table format when there's a lot of data, which makes it much
-- easier to read.
\x auto

-- Verbose error reports.
\set VERBOSITY verbose

-- Use a separate history file per-database.
\set HISTFILE ~/.psql_history- :DBNAME

-- If a command is run more than once in a row, only store it once in the
-- history.
\set HISTCONTROL ignoredups

-- Autocomplete keywords (like SELECT) in upper-case, even if you started
-- typing them in lower case.
\set COMP_KEYWORD_CASE upper