.psqlrc

\setenv LESS '-iMSx4FXRe'
\pset pager always
\pset null ¤
\pset linestyle unicode
\pset border 2

-- Returns query time cost with each order
\timing

-- Returns more information on errors
\set VERBOSITY verbose

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

-- ":locks" command returns dabase locks
\set locks 'SELECT bl.pid AS blocked_pid, a.usename AS blocked_user, ka.query AS blocking_statement, now() - ka.query_start AS blocking_duration, kl.pid AS blockin g_pid, ka.usename AS blocking_user, a.query AS blocked_statement, now() - a.query_start AS blocked_duration FROM pg_catalog.pg_locks bl JOIN pg_catalog.pg_stat_activity a ON a.pid = bl.pid JOIN pg_catalog.pg_locks kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid WHERE NOT bl.granted;'

-- ":clear" command clears screen
\set clear '\\! clear;'