aboutsummaryrefslogtreecommitdiff
path: root/psqlrc
diff options
context:
space:
mode:
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 ''
+