Added the psqlrc file

2 files changed, 18 insertions, 0 deletions

diff --git a/install.sh b/install.sh
index 6563706..8b89dcb 100755
--- a/install.sh
+++ b/install.sh
@@ -6,6 +6,7 @@ set -e
 
 # Install the files on this repo.
 cp bashrc $HOME/.bashrc
+cp psqlrc $HOME/.psqlrc
 cp irbrc $HOME/.irbrc
 cp gemrc $HOME/.gemrc
 cp gitcompletion.sh $HOME/.gitcompletion.sh
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 ''
+