Update fzf location
[dotfiles] / .psqlrc
1 -- See http://www.postgresql.org/docs/9.6/static/app-psql.html for the list of other useful variables
2
3 -- Be quiet during loading of this file
4 \set ECHO none
5 -- set client_min_messages = fatal;
6
7 -- makes running script stop on the 1st error
8 -- \set ON_ERROR_STOP 1
9
10 -- display null values as [null], instead of blank
11 \pset null '[null]'
12
13 \set COMP_KEYWORD_CASE upper
14
15 -- one history file per database
16 \set HISTFILE ~/.psql_history- :DBNAME
17 \set HISTSIZE 2000
18
19 -- have all queries display query times
20 \timing
21
22 -- prompt customization
23 \set PROMPT1 '%[%033[31;5m%]%x%[%033[0m%]%[%033[31;1m%]%n%[%033[33;1m%]@%[%033[32;1m%m%[%033[0m%] %[%033[37;1m%]%/%[%033[0m%] %`date +"%H:%M:%S"` %#'
24 \set PROMPT2 '[more] %R > '
25
26 -- Verbose error reports.
27 \set VERBOSITY verbose
28
29 -- unicode
30 \encoding unicode
31
32 -- switch to expanded table format for large results
33 \x auto
34
35 -- custom shortcuts
36 \set settings 'select name, setting,unit,context from pg_settings;'
37
38
39 -- Okay, be noisy again
40 -- set client_min_messages = warning;
41 -- When running scripts, echos all commmands to stdout.
42 \set ECHO all