(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 ...
Recent Posts
(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...
(TIL) PSQL: Send A Command To psql
You can send a command to psql to be executed by using the -c flag
(TIL) PSQL: Use a psqlrc File For Common Settings
There are a handful of settings that I inevitably turn on or configure each time I open up a psql session. I can save myself a little time and sanity by conf...
(TIL) PSQL: A Better Null Display Character
By default, psql will display null values with whitespace. This makes it difficult to quickly identify null values when they appear amongst a bunch of other ...