.psqlrc

Sat, 30 Dec 2017 20:56:50 -0500

author
Meredith Howard <mhoward@roomag.org>
date
Sat, 30 Dec 2017 20:56:50 -0500
changeset 665
807f6539d9cc
parent 220
a51ef0e93f75
permissions
-rw-r--r--

housekeeping

220
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
1 \set QUIET 1
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
2
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
3 -- complete keywords in upper case
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
4 \set COMP_KEYWORD_CASE upper
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
5
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
6 -- automatically use expanded display
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
7 \x auto
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
8
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
9 -- display nulls as...
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
10 \pset null ยค
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
11
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
12 -- Verbose error reports.
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
13 \set VERBOSITY verbose
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
14
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
15 -- Use a separate history file per-database, no dupes
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
16 \set HISTFILE ~/.psql_history- :DBNAME
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
17 \set HISTCONTROL ignoredups
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
18
a51ef0e93f75 add psqlrc
Meredith Howard <mhoward@roomag.org>
parents:
diff changeset
19 \unset QUIET

mercurial