-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path.psqlrc
44 lines (30 loc) · 931 Bytes
/
.psqlrc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
-- unicode!
\pset linestyle unicode
\encoding unicode
-- well defined history file
\set HISTFILE ~/.psql_history- :HOST - :DBNAME
\set HISTSIZE 2000
-- disable autocommit
-- \unset AUTOCOMMIT
-- each statement creates a checkpoint, roll it back on error
-- \set ON_ERROR_ROLLBACK
-- stop execution when an error occurs
-- \set ON_ERROR_STOP
-- pretty borders
\pset border 2
-- wrap columns rather than make ugly rows
\pset format wrapped
-- nulls are easy to distinguish
--\pset null ¤
--\pset null '(╯°□°)╯︵ ┻━┻)'
\pset null 'ヽ༼ ಠ益ಠ ༽ノ'
-- purdy prompt
\set PROMPT1 '(%[%033[33;1m%]%n@%/%[%033[0m%])%x [psql]> '
\set PROMPT2 '(%[%033[33;1m%]%n@%/%[%033[0m%])%x [psql]| '
-- display timing information
\timing
\x auto
-- terse verbosity, when looking for compilation errors please make sure to change
-- to \set VERBOSITY all
\set VERBOSITY terse
\set PSQL_EDITOR /usr/local/bin/nvim