(TIL) PSQL: String Contains Another String
You can check if a string contains another string using the position function.
Recent Posts
(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...
(TIL) PSQL: Generating UUIDs With pgcrypto
If you check out the docs for the uuid-ossp extension, you’ll come across the following message.
(TIL) PSQL: Compute Hashes With pgcrypto
The pgcrypto extension that comes with PostgreSQL adds access to some general hashing functions. Included are md5, sha1, sha224, sha256, sha384 and sha512. A...
(TIL) PSQL: List Various Kinds Of Objects
Our PostgreSQL database can end up with all kinds of objects: tables, sequences, views, etc. We can use a variety of psql meta-commands to list the different...