/* Code Comments */

Reminder: Logging Into Postgres With Shell Commands

August 19, 2019

PGAdmin, Dbeaver, etc. are useful GUIs for managing and reviewing Postgres databases. Sometimes, however, there’s a desire to login via the CLI.

Every time I have this happen, I need to look it up again - so, I’m writing it down to hopefully make that search shorter in the future: psql -h <db host name> -U <your username> -d postgres.

Note, I’m using psql here - which is a “terminal-based front-end to Postgres.”1

Footnotes

  • 1 For more about psql, see the manual page in your terminal with man psql

Stephen Weiss

Thanks for reading! My name's Stephen Weiss. I live in Chicago with my wife, Kate, and dog, Finn.
Click here to see the archives of my weeks in review and sign up yourself!