Postgres
Joining between date and timestamp fields in Postgres
A note-to-self on avoiding DST issues when joining between tables.
Using pgbadger with AWS RDS
Two gotchas that I wasted time on.
Copying Postgres output into a spreadsheet
Quick tip on tweaking the output of psql
Backing up Postgres database rows before deleting them
Quick tip on avoiding accidental data loss
Dumping and restoring a PostGIS database
Harder than it should be
Altering Postgres table columns with South
Using ‘USING’ to cast correctly
Configuring logging for Postgres.app
The recommended way of debugging SQL problems