-- Autocomplete UPPER CASE SQL
\set COMP_KEYWORD_CASE upper

-- Expand tables automatically
\pset expanded auto

-- Show NULL as
\pset null '[NULL]'

-- Output time command took to execute
\timing

-- Use pager when needed
\pset pager on

-- Larger history
\set HISTSIZE 10000

-- Save history to $XDG_STATE_HOME
\getenv xdg_state_home XDG_STATE_HOME
\set HISTFILE :xdg_state_home/psql_history

-- If this variable is set to ignorespace, lines which begin with a space are
-- not entered into the history list. If set to a value of ignoredups, lines
-- matching the previous history line are not entered. A value of ignoreboth
-- combines the two options. If set to none (the default), all lines read in
-- interactive mode are saved on the history list.
\set HISTCONTROL ignoreboth