aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Ryder <tom@sanctum.geek.nz>2013-09-16 19:33:59 +1200
committerTom Ryder <tom@sanctum.geek.nz>2013-09-16 19:33:59 +1200
commit90b43201e560e0c0dd6af23520328161e2a03f0a (patch)
treec4454733accec8192bcc150650b0da907dfd6045
parentAdded basic dotfiles for mysql/psql (diff)
downloaddotfiles-90b43201e560e0c0dd6af23520328161e2a03f0a.tar.gz
dotfiles-90b43201e560e0c0dd6af23520328161e2a03f0a.zip
Standard approach to database prompts
-rw-r--r--mysql/my.cnf3
-rw-r--r--psql/psqlrc2
2 files changed, 3 insertions, 2 deletions
diff --git a/mysql/my.cnf b/mysql/my.cnf
index 1c55c791..be035865 100644
--- a/mysql/my.cnf
+++ b/mysql/my.cnf
@@ -1,3 +1,4 @@
[mysql]
-prompt='(\u@\h)\n[\d] mysql> '
+prompt='(\u@\h:\d) mysql> '
+safe-updates
diff --git a/psql/psqlrc b/psql/psqlrc
index e3f4434b..d58e73e9 100644
--- a/psql/psqlrc
+++ b/psql/psqlrc
@@ -1,6 +1,6 @@
\encoding unicode
\pset null 'NULL'
\set HISTSIZE 1000000
-\set PROMPT1 '(%n@%M:%>)\n[%/] psql> '
+\set PROMPT1 '(%n@%M:%>:%/) psql> '
\timing