Here is my ~/.psqlrc: \pset pager \pset null 'NULL' \timing \encoding unicode SET search_path=public,postgis The first line turns off pagi

Here is my ~/.psqlrc: \pset pager \pset null 'NULL' \timing \encoding unicode SET search_path=public,postgis The first line turns off paging, since I dislike how paging causes previous queries/results to disappear after I press q. The second line is like the article's. `\timing` shows how long each query took to run. I honestly don't remember why/if `\encoding unicode` was necessary. Playing nice with my terminal? Writing to a file with `\o`? The `search_path` line is because I often install PostGIS objects in a `postgis` schema, and this lets me reference them without a prefix. If there is no `postgis` schema I get a warning when I start psql, but that's no bother to me.