.psqlrc

-- Be quiet when setting commands from this file
\set QUIET 1
-- Nicer prompt
\set PROMPT1 '%[%033[32;1m%]%n@%m%[%033[0m%] %[%033[31m%]<%/%[%033[35m%]%x%[%033[0m%]%[%033[35m%]%[%033[31m%]>%[%033[0m%] %[%033[34m%]%#%[%033[0m%] '
\set PROMPT2 '> '
\set PROMPT3 '>> '
-- Display null values as [NULL]
\pset null '[NULL]'
-- Switch to expanded table format when there's a lot of data
\x auto
-- Verbose error reports
\set VERBOSITY verbose
-- Use a separate history file per-database
\set HISTFILE ~/.psql_history- :DBNAME
-- Don't store duplicate records in history file
\set HISTCONTROL ignoredups
-- Autocomplete keywords (like SELECT) in upper-case
\set COMP_KEYWORD_CASE upper
\pset border 2
-- Time commands execution
\timing
-- Unset QUIET set at the beggining of this file
\unset QUIET