Recent Posts

(TIL) PSQL: Insert Just The Defaults

less than 1 minute read

If you are constructing an INSERT statement for a table whose required columns all have default values, you may just want to use the defaults. In this situat...

(TIL) PSQL: Generate Series Of Numbers

less than 1 minute read

Postgres has a generate_series function that can be used to, well, generate a series of something. The simplest way to use it is by giving it start and stop ...

(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...