aboutsummaryrefslogtreecommitdiff
path: root/psqlrc
diff options
context:
space:
mode:
authorMiquel Sabaté <mikisabate@gmail.com>2013-11-08 16:57:20 +0000
committerMiquel Sabaté <mikisabate@gmail.com>2013-11-08 16:57:20 +0000
commitc93317c9e73da8781f7ecd49c5ee68ad647332bb (patch)
treee57f14826a60e74a36c65907313e2a076a4278b6 /psqlrc
parentc1a0e2b3948e18a34e312f5a79f6802d0c06c0bb (diff)
downloaddotfiles-c93317c9e73da8781f7ecd49c5ee68ad647332bb.tar.gz
dotfiles-c93317c9e73da8781f7ecd49c5ee68ad647332bb.zip
Added the psqlrc file
Diffstat (limited to 'psqlrc')
-rw-r--r--psqlrc17
1 files changed, 17 insertions, 0 deletions
diff --git a/psqlrc b/psqlrc
new file mode 100644
index 0000000..59d25f9
--- /dev/null
+++ b/psqlrc
@@ -0,0 +1,17 @@
+
+-- Show null values to NULL so we can distinguish them from empty strings.
+\pset null NULL
+
+-- Set expanded display on (why isn't this the default behaviour ?)
+\x
+
+-- Show how long a query took to be executed.
+\timing
+
+-- Because everybody loves unicode.
+\encoding unicode
+
+-- Set a beautiful prompt :P
+\set PROMPT1 '%n@%/ > '
+\set PROMPT2 ''
+