aboutsummaryrefslogtreecommitdiffstats
path: root/.psqlrc
diff options
context:
space:
mode:
Diffstat (limited to '.psqlrc')
-rw-r--r--.psqlrc8
1 files changed, 5 insertions, 3 deletions
diff --git a/.psqlrc b/.psqlrc
index 8e774e6..415a184 100644
--- a/.psqlrc
+++ b/.psqlrc
@@ -2,7 +2,7 @@
/* prompts */
\set PROMPT1 '\x1b[38;5;34m%n\x1b[0m@\x1b[38;5;39m%M\x1b[0m:\x1b[38;5;37m%> \x1b[38;5;69m%`date +%H:%M:%S` \x1b[38;5;4m[%/] \x1b[38;5;31m%x\x1b[38;5;104m%#\x1b[38;5;34m%R\n\x1b[38;5;28m>>>\x1b[0m'
-\set PROMPT2 '\x1b[38;5;39m%M\x1b[0m:\x1b[38;5;37m%> \x1b[38;5;34m%n\x1b[0m@\x1b[38;5;4m%/\x1b[38;5;34m%R \x1b[38;5;104m%# \n\x1b[38;5;28m>>>\x1b[0m'
+\set PROMPT2 '... '
\set PROMPT3 '\x1b[38;5;38m>>>\x1b[0m'
\pset null '[null]'
@@ -16,9 +16,8 @@
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
-
\set ON_ERROR_STOP on
-\set ON_ERROR_ROLLBACK off
+\set ON_ERROR_ROLLBACK interactive
\set COMP_KEYWORD_CASE upper
@@ -26,4 +25,7 @@
\pset unicode_column_linestyle single
\pset unicode_header_linestyle double
+\set version 'SELECT version();'
+\set extensions 'select * from pg_available_extensions;'
+
\unset QUIET