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...
Recent Posts
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...
PSQL: List Database Users
Within psql, type \du to list all the users for a database and their respective permissions.
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.
PSQL: List All The Databases
There are two ways to list all the available databases. The first is a psql only command: