PostgreSQL CLI Setup(sandrock.co.za)
sandrock.co.za
PostgreSQL CLI Setup
https://sandrock.co.za/carl/2026/05/my-postgresql-cli-setup/
3 comments
Good setup. One thing worth adding — pgpass file for credential management if you're connecting to multiple databases. Saves a lot of repeated password entry across environments.
`.pgpass` is the second item in the setup after `.pg_service.conf`.
Tips for making the CLI expierience nicer for PostgeSQL databases