(TIL) PSQL: Limit Execution Time Of StatementsSpecial Math Operators
Postgres has all the mathematical operators you might expect in any programming language (e.g. +,-,*,/,%). It also has a few extras that you might not be exp...
Recent Posts
(TIL) PSQL: Find The Location Of Postgres Config Files
If you can connect to your database with psql, then you can easily find the location of your Postgres config files. After connecting, I can ask Postgres to s...
(TIL) PSQL: Find The Data Directory
Where does postgres store all of the data for a database cluster? Well, in its data directory. Where exactly that data directory is can depend on how the dat...
(TIL) PSQL: Configure The Timezone
Running show timezone; will reveal the timezone for your postgres connection. If you want to change the timezone for the duration of the connection, you can ...
(TIL) PSQL: Set A Seed For The Random Number Generator
In PostgreSQL, the internal seed for the random number generator is a run-time configuration parameter. This seed parameter can be set to a particular seed i...