From 89d08f8344c521977d027e2c2831540f72674915 Mon Sep 17 00:00:00 2001 From: Anton Bobov Date: Sat, 8 Feb 2020 23:23:28 +0500 Subject: Updates. --- files/.psqlrc | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 files/.psqlrc (limited to 'files/.psqlrc') diff --git a/files/.psqlrc b/files/.psqlrc new file mode 100644 index 0000000..8d3e0ad --- /dev/null +++ b/files/.psqlrc @@ -0,0 +1,23 @@ +-- Official docs: http://www.postgresql.org/docs/current/static/app-psql.html +-- Unofficial docs: http://robots.thoughtbot.com/improving-the-command-line-postgres-experience + +\set QUIET 1 + +\pset null '[NULL]' +\pset border 2 + +\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# ' +\set PROMPT2 '[more] %R > ' + +-- Show how long each query takes to execute +\timing + +-- Use best available output format +\x auto +-- Maintain a separate history for each database. +\set HISTFILE ~/.psql_history- :DBNAME +\set HISTCONTROL ignoreboth + +\unset QUIET + +-- vim: ft=sql : -- cgit v1.2.3