Recent Posts

(TIL) PSQL: Export Query Results To A CSV

less than 1 minute read

Digging through the results of queries in Postgres’s psql is great if you are a programmer, but eventually someone without the skills or access may need to c...

(TIL) PSQL: Clear The Screen In psql

less than 1 minute read

The psql interactive terminal does not have a built-in way of clearing the screen. What I usually do if I really need the screen cleared is quit, run clear f...

(TIL) PSQL: Storing Emails With citext

less than 1 minute read

Email addresses should be treated as case-insensitive because they are. If a user is trying to sign in with their email address, we shouldn’t care if they ty...

(TIL) PSQL: Getting A Slice Of An Array

less than 1 minute read

Postgres has a very natural syntax for grabbing a slice of an array. You simply add brackets after the array declaring the lower and upper bounds of the slic...