Created
June 23, 2017 15:08
-
-
Save mble/2669e0fb69453088702d2077a6290878 to your computer and use it in GitHub Desktop.
My psqlrc
This file contains 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
-- Don't display the "helpful" message on startup. | |
\set QUIET 1 | |
\pset null '[NULL]' | |
\pset linestyle unicode | |
\pset border 2 | |
-- http://www.postgresql.org/docs/9.3/static/app-psql.html#APP-PSQL-PROMPTING | |
\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# ' | |
-- PROMPT2 is printed when the prompt expects more input, like when you type | |
-- SELECT * FROM<enter>. %R shows what type of input it expects. | |
\set PROMPT2 '[more] %R > ' | |
-- Show how long each query takes to execute | |
\timing | |
-- Use best available output format | |
\x auto | |
\set VERBOSITY verbose | |
\set HISTFILE ~/.psql_history- :DBNAME | |
\set HISTCONTROL ignoredups | |
\set COMP_KEYWORD_CASE upper | |
\unset QUIET |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment