Psql is a command-line interface for interacting with PostgreSQL, a powerful and open source relational database system. Brew is a package manager for macOS that makes it easy to install and manage software. Here are the steps to install psql with brew:
- First, install the brew package manager if you don’t have it already. You can do this by running the following command in your terminal:
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
- Second, update brew by running the following commands:
brew doctor brew update
- Third, install libpq by running the command:
brew install libpq
Libpq is a library that contains psql and other PostgreSQL client utilities.
- Fourth, symlink psql (and other libpq tools) into /usr/local/bin by running the command:
brew link --force libpq
This will make psql accessible from any directory in your terminal.
- Fifth, check the version of PostgreSQL using the psql command:
You should see something like this:
psql (PostgreSQL) 13.4
Congratulations, you have successfully installed psql with brew! You can now use psql to connect to PostgreSQL databases and run SQL queries.