psqlrc

--                  _
--  _ __  ___  __ _| |_ __ ___
-- | '_ \/ __|/ _` | | '__/ __|
-- | |_) \__ \ (_| | | | | (__
-- | .__/|___/\__, |_|_|  \___|
-- |_|           |_|

-- Style the prompts
\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# '
\set PROMPT2 '[more] %R > '

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

-- While using cli warn for non-atomic actions
\set ON_ERROR_ROLLBACK interactive

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