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