A .psqlrc file gathered from various sources, for use with PostgreSQL

.psqlrc

-- Set client encoding
\encoding UTF8

\set QUIET 1

-- print 'NULL' (instead of a blank) for any columns that have a null value
\pset null 'NULL'

-- Do not automatically commit after every statement
\set AUTOCOMMIT off

-- Set auto-completed keywords to upper case
\set COMP_KEYWORD_CASE upper

-- Verbose feedback
\set VERBOSITY verbose

-- Keep a separate history file for each database
\set HISTFILE ~/.psql_history- :DBNAME

-- Ignore duplicate entries and lines that begin with a space
\set HISTCONTROL ignoreboth

-- print 'NULL' (instead of a blank) for any columns that have a null value
\pset null 'NULL'

-- Use 'pretty' unicode lines when displaying results
\pset linestyle unicode

-- Draw a border around the outside of query results
\pset border 2

--  Wrap long lines so they will fit in the display
\pset format wrapped

-- Scroll results automatically
\pset pager off

-- Display how long queries take to run
\timing

-- Change to the "expanded" view when rows are too wide to fit
\x auto

-- Set the prompt.  Leave the PROMPT2 empty, making it easier to copy multiline queries from
-- psql to other editors
\set PROMPT1 '%n@%m:%>/%/%x%# '
\set PROMPT2 ''

-- Set bytea output to show as many ASCII letters as possible.
-- (Handy if you are storing text whose encoding you do not know in bytea columns.)
set bytea_output to escape; commit;

\unset QUIET