Craig Kerstiens lets loose with his preferred interface to Postgres:
Sometimes it leans more to, what is the Sequel Pro equivilant for Postgres. My default answer is I just use psql, though I do have to then go on to explain how I use it. For those just interested you can read more below or just get the highlights here:
There’s a few handy TILs in there.