git.nskm.xyz Git - dotfiles/blob - .psqlrc

   1 -- See http://www.postgresql.org/docs/9.6/static/app-psql.html for the list of other useful variables
   2
   3 -- Be quiet during loading of this file
   4 \set ECHO none
   5 -- set client_min_messages = fatal;
   6
   7 -- makes running script stop on the 1st error
   8 -- \set ON_ERROR_STOP 1
   9
  10 -- display null values as [null], instead of blank
  11 \pset null '[null]'
  12
  13 \set COMP_KEYWORD_CASE upper
  14
  15 -- one history file per database
  16 \set HISTFILE ~/.psql_history- :DBNAME
  17 \set HISTSIZE 2000
  18
  19 -- have all queries display query times
  20 \timing
  21
  22 -- prompt customization
  23 \set PROMPT1 '%[%033[31;5m%]%x%[%033[0m%]%[%033[31;1m%]%n%[%033[33;1m%]@%[%033[32;1m%m%[%033[0m%] %[%033[37;1m%]%/%[%033[0m%] %`date +"%H:%M:%S"` %#'
  24 \set PROMPT2 '[more] %R > '
  25
  26 -- Verbose error reports.
  27 \set VERBOSITY verbose
  28
  29 -- unicode
  30 \encoding unicode
  31
  32 -- switch to expanded table format for large results
  33 \x auto
  34
  35 -- custom shortcuts
  36 \set settings 'select name, setting,unit,context from pg_settings;'
  37
  38
  39 -- Okay, be noisy again
  40 -- set client_min_messages = warning;
  41 -- When running scripts, echos all commmands to stdout.
  42 \set ECHO all