aboutsummaryrefslogtreecommitdiff
path: root/.psqlrc
diff options
context:
space:
mode:
authorPatrick Spek <p.spek@tyil.nl>2020-02-24 16:45:45 +0100
committerPatrick Spek <p.spek@tyil.nl>2021-08-14 11:59:31 +0200
commita2e34288db191eb7fa16377ee061592539665d66 (patch)
tree95756b9b41f4a645a2fc3fc7bb1197d519260a60 /.psqlrc
parent1e687203e445578870423869928278eeaceaf2c1 (diff)
Add psqlrc
Diffstat (limited to '.psqlrc')
-rw-r--r--.psqlrc15
1 files changed, 15 insertions, 0 deletions
diff --git a/.psqlrc b/.psqlrc
new file mode 100644
index 0000000..7425862
--- /dev/null
+++ b/.psqlrc
@@ -0,0 +1,15 @@
+-- Set the prompt
+\set PROMPT1 '%[%033[35m%]%M:%>%[%033[0m%]/%[%033[32m%]%n%[%033[0m%]@%[%033[34m%]%/%[%033[0m%] %x%R%# '
+\set PROMPT2 '%[%033[35m%]%M:%>%[%033[0m%]/%[%033[32m%]%n%[%033[0m%]@%[%033[34m%]%/%[%033[0m%] %x%R%# '
+
+-- Set NULL character
+\pset null Ø
+
+-- Complete keywords in upper case
+\set COMP_KEYWORD_CASE upper
+
+-- Show query times
+\timing on
+
+-- Use extended display by default
+\x auto