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...
Recent Posts
PSQL: Send A Command To psql
You can send a command to psql to be executed by using the -c flag
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...
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 ...
PSQL: String Contains Another String
You can check if a string contains another string using the position function.