Skip to content

Instantly share code, notes, and snippets.

@Taragolis
Created July 4, 2017 09:28
Show Gist options
  • Save Taragolis/2be4798c592c4b9b3f13ef227289df0d to your computer and use it in GitHub Desktop.
Save Taragolis/2be4798c592c4b9b3f13ef227289df0d to your computer and use it in GitHub Desktop.
psql interactive shell config file
\set QUIET ON
\set HISTFILE ~/.psql_history- :HOST - :DBNAME
\set HISTSIZE 2000
\set COMP_KEYWORD_CASE upper
\x
\pset linestyle unicode
\pset border 2
\pset null '[NULL]'
\set PROMPT1 '%[%033[30;42m%] psql %[%033[32;40m%] %[%033[39m%]%m %[%033[37m%]%/ %[%033[30;44m%]%[%033[30;44m%] %R %[%033[34;49m%] %[%033[0m%]'
\set PROMPT2 '%[%033[30;42m%] psql %[%033[32;40m%] %[%033[39m%]%m %[%033[37m%]%/ %[%033[30;44m%]%[%033[30;44m%] %R %[%033[34;49m%] %[%033[0m%]'
\set PROMPT3 '%[%033[30;42m%] psql %[%033[32;44m%] %[%033[30;44m%]copy %[%033[34;49m%] %[%033[0m%]'
\pset pager off
\pset format wrapped
\timing
\encoding unicode
\unset quiet
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment