Postgres

November 16, 2017
Joining between date and timestamp fields in Postgres

A note-to-self on avoiding DST issues when joining between tables.

August 29, 2017
Using pgbadger with AWS RDS

Two gotchas that I wasted time on.

September 02, 2015
Copying Postgres output into a spreadsheet

Quick tip on tweaking the output of psql

March 19, 2015
Backing up Postgres database rows before deleting them

Quick tip on avoiding accidental data loss

July 28, 2013
Dumping and restoring a PostGIS database

Harder than it should be

February 19, 2013
Altering Postgres table columns with South

Using ‘USING’ to cast correctly

January 14, 2013
Configuring logging for Postgres.app

The recommended way of debugging SQL problems