(TIL) PSQL: Sets With The Values Command
You can concisely create sets of values in PostgreSQL using the values command.
Recent Posts
(TIL) PSQL: Who Is The Current User
You can determine the current user of a psql session by selecting on the current_user
(TIL) PSQL: Use Argument Indexes
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...
(TIL) PSQL: Use unlogged tables for caches
Using a Postgres table for caching? You might want to try making it unlogged.
(TIL) PSQL: Types By Category
Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of the...