(TIL) PSQL: Generating UUIDs With pgcrypto
If you check out the docs for the uuid-ossp extension, you’ll come across the following message.
Recent Posts
(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...
(TIL) PSQL: List Database Users
Within psql, type \du to list all the users for a database and their respective permissions.
(TIL) PSQL: List Database Objects With Disk Usage
I’ll often times use \d or \dt to check out the tables in my database. This shows the schema, object name, object type (e.g. table), and owner for each.