Skip to content

Instantly share code, notes, and snippets.

@marklit
Created October 28, 2015 08:25
Show Gist options
  • Select an option

  • Save marklit/4713c396fa4c01805cb6 to your computer and use it in GitHub Desktop.

Select an option

Save marklit/4713c396fa4c01805cb6 to your computer and use it in GitHub Desktop.
Postgres psql customisations
\set PROMPT1 '%[%033[1;33m%]%M:%>%[%033[1;32m%] %n@%/%R%[%033[0m%]%# '
\set PROMPT2 ' %R > '
\x auto
\timing
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\set COMP_KEYWORD_CASE upper
\pset null '¤'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment