-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathpsqlrc
33 lines (28 loc) · 859 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
\timing
\encoding UTF8
-- Prompt on xterm title:
-- %033]0;psql %M:%> %n@%~%R%#%x%007
-- \set PROMPT1 '%M:%> %n@%~%R%#%x %033]0;psql %M:%> %n@%~%R%#%x%007 '
\set PROMPT1 '%l %n@%M:%>/%/ %x%# '
\set PROMPT2 '%l %R %x> '
\set PROMPT3 = '%l >> '
\set ON_ERROR_STOP on
\set ON_ERROR_ROLLBACK interactive
-- Ensure autocompleted keywords stay lowercase
\set COMP_KEYWORD_CASE lower
\set HISTSIZE 50000
\set HISTFILE ~/tmp/psql-history/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\set VERBOSITY verbose
\pset linestyle 'unicode'
\pset unicode_border_linestyle single
\pset unicode_column_linestyle single
\pset unicode_header_linestyle double
\pset pager off
-- \pset null '[__null__]'
\pset null '¤'
\x auto
set intervalstyle to 'postgres_verbose';
-- Prevent Ctrl-D from exiting psql.
\set IGNOREEOF 5
-- display application name in pg_stat_activity