aboutsummaryrefslogtreecommitdiff
path: root/files/.psqlrc
blob: 119026d4a2b2bce6a4383602c140d8ee2f9d8da4 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- Official docs: http://www.postgresql.org/docs/current/static/app-psql.html
-- Unofficial docs: http://robots.thoughtbot.com/improving-the-command-line-postgres-experience

\set QUIET 1

\pset null '[NULL]'
\pset border 2
\pset linestyle unicode

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

-- Show how long each query takes to execute
\timing

-- Use best available output format
\x auto
-- Maintain a separate history for each database.
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoreboth

\unset QUIET

-- vim: ft=sql :