Recent Posts

(TIL) PSQL: Change The Current Directory

less than 1 minute read

When you start a psql session, your current directory is what psql will use as its current directory. This is important for meta-commands that use relative p...

(TIL) PSQL: Auto Expanded Display

less than 1 minute read

By default, postgres has expanded display turned off. This means that results of a query are displayed horizontally. At times, the results of a query can be ...

(TIL) PSQL: Use Argument Indexes

less than 1 minute read

In Postgres, each of the arguments you specify in a select statement has a 1-based index tied to it. You can use these indexes in the order by and group by p...