.psqlrc

-- Include the hostname in the prompt, and add a * when in a transaction
-- The default PROMPT2 doesn't make it obvious enough nothing has been sent to the server yet
\set PROMPT1 '%M:%/%R%x%# '
\set PROMPT2 '> '

-- Always be in a transaction. It's safer this way
\set AUTOCOMMIT off

-- Turn the pager on always. This is best used with "export PAGER=less -S -F -X" added to your .bashrc
\pset pager always

-- History files stored in the .psql_history directory in the form <hostname>-<dbname>
\set HISTFILE ~/.psql_history/:HOST - :DBNAME
\set HISTSIZE 2000

-- Always display timing information.
\timing

\encoding unicode