Last active
November 9, 2018 13:04
-
-
Save jelder/1345ff7cd82e57781b7108452b9182d6 to your computer and use it in GitHub Desktop.
My ~/.psqlrc
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[mysql] | |
prompt=\\d mysql>\_ | |
auto-vertical-output=true |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
\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