Skip to content

Instantly share code, notes, and snippets.

@jelder
Last active November 9, 2018 13:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jelder/1345ff7cd82e57781b7108452b9182d6 to your computer and use it in GitHub Desktop.
Save jelder/1345ff7cd82e57781b7108452b9182d6 to your computer and use it in GitHub Desktop.
My ~/.psqlrc
[mysql]
prompt=\\d mysql>\_
auto-vertical-output=true
\set QUIET 1
-- The previous line just suppresses the output of the following lines.
-- Full documentation for these options: https://www.postgresql.org/docs/current/static/app-psql.html
\set ON_ERROR_ROLLBACK interactive
\set COMP_KEYWORD_CASE upper
\set VERBOSITY verbose
\set HISTFILE ~/.psql/history- :DBNAME
\set HISTCONTROL ignoredups
-- Report something unambiguously null instead of a blank string
\pset null '␀'
-- Report query times (includes network round trip)
\timing
-- Automatically switch to column-per-line mode for result sets wider than terminal.
\x auto
\unset QUIET
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment