Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
30 lines (23 sloc) 866 Bytes
-- vim: ft=sql
-- Official docs: http://www.postgresql.org/docs/9.3/static/app-psql.html
-- http://craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/
-- https://github.com/hgmnz/dotfiles/blob/master/psqlrc
-- Remove this:
-- Null display is "[NULL]".
-- Expanded display is used automatically.
-- psql (9.3.1)
-- Type "help" for help.
\set QUIET 1
\pset null '[NULL]'
-- 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 > '
-- 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