Installation

# link psql manually using Brew
## when psql is installed but not detected in cli
brew link postgresql@15

# check psql version
postgres -V

# configure `PATH` for psql15
echo 'export PATH="/opt/homebrew/opt/postgresql@15/bin:$PATH"' >> ~/.zshrc

# connect to db directly from cli
psql postgresql://<db_name>:<db_pw>@localhost:<port_num>/<db_env_name>

# run psql15 local server
brew services start postgresql@15

Console Commands

# open psql console
psql postgres

# list tables
\d

# find local port and users
\conninfo