add psql settings

1 files changed, 10 insertions, 0 deletions

diff --git a/.psqlrc b/.psqlrc
new file mode 100644
index 0000000..a1026b6
--- /dev/null
+++ b/.psqlrc
@@ -0,0 +1,10 @@
+\set QUIET
+\set HISTFILE          ~/.cache/psql/:DBNAME
+\set HISTSIZE          2000
+\set HISTCONTROL       ignoredups
+\set COMP_KEYWORD_CASE lower
+\pset linestyle        unicode
+\pset null             'NULL'
+\timing                on
+\set PROMPT1           '%n@%m %/$ '
+\set PROMPT2           ''