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...
Recent Posts
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.
PSQL: Salt And Hash A Password With pgcrypto
The pgcrypto extension that ships with PostgreSQL can be used to do a number of interesting things. This includes functions for doing salted password hashing...
PSQL: Generating UUIDs With pgcrypto
If you check out the docs for the uuid-ossp extension, you’ll come across the following message.