Recent Posts

(TIL) PSQL: Compute Hashes With pgcrypto

less than 1 minute read

The pgcrypto extension that comes with PostgreSQL adds access to some general hashing functions. Included are md5, sha1, sha224, sha256, sha384 and sha512. A...

(TIL) PSQL: List Various Kinds Of Objects

less than 1 minute read

Our PostgreSQL database can end up with all kinds of objects: tables, sequences, views, etc. We can use a variety of psql meta-commands to list the different...