Recent Posts

PSQL: Compute Hashes With pgcrypto

less than 1 minute read

The pgcrypto extension that comes with PostgreSQL adds access to some general hashing functions. Included are md5, sha1, sha224, sha256, sha384 and sha512. A...

PSQL: List Various Kinds Of Objects

less than 1 minute read

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...

PSQL: List Database Users

less than 1 minute read

Within psql, type \du to list all the users for a database and their respective permissions.

PSQL: List Database Objects With Disk Usage

less than 1 minute read

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.