Recent Posts

PSQL: Use a psqlrc File For Common Settings

less than 1 minute read

There are a handful of settings that I inevitably turn on or configure each time I open up a psql session. I can save myself a little time and sanity by conf...

PSQL: A Better Null Display Character

less than 1 minute read

By default, psql will display null values with whitespace. This makes it difficult to quickly identify null values when they appear amongst a bunch of other ...

PSQL: Salt And Hash A Password With pgcrypto

less than 1 minute read

The pgcrypto extension that ships with PostgreSQL can be used to do a number of interesting things. This includes functions for doing salted password hashing...