forked from toranb/dotfiles
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpsqlrc
More file actions
19 lines (13 loc) · 638 Bytes
/
psqlrc
File metadata and controls
19 lines (13 loc) · 638 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
\set PROMPT1 '\n%[%033[1;37m%]┌──(%033[1;34m%]User:%[%033[32m%]%n%[%033[34m%] Port:%[%033[32m%]%>%[%033[34m%] DB:%[%033[32m%]%/%033[37m%])%033[0m%]\n└─➤ '
-- Make null display as NULL and not an empty string
\pset null '[NULL]'
-- Table format default expanded format when too much data for one screen
\x auto
-- Verbose error reports.
\set VERBOSITY verbose
-- Use a separate history file per-database.
\set HISTFILE ~/.psql_history- :DBNAME
-- If command run more than once in a row, only store once in history.
\set HISTCONTROL ignoredups
-- complete keywords (like SELECT) in upper-case
\set COMP_KEYWORD_CASE upper