» pip install pgcli
Appears "the way" to install the client, if you want to use hombrew, is:
brew install postgresql@15
(you need to specify the version after @) then psql (the client command line) will now be available to you (it also installs a local Postgres server/database, but you don't have to use that if all you want is the client).
Apparently there's also a 'wrapper' to the psql command to make it more "user friendly" also available via homebrew (brew install pgcli) in case interesting. Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.
Another option is to install the libpq homebrew package, but it doesn't get in your PATH.
brew install libpq
So follow the instructions it says after install out to add it to your PATH, or brew link --force libpq or add a symlink.
Locate the psql binary. (In a terminal, run locate psql | grep /bin, and make note of the path. (In my case, it's /opt/local/lib/postgresql90/bin/, as it was installed using MacPorts.)
Then, edit the .bash_profile file in your home folder (e.g. mate -w ~/.bash_profile assuming you've textmate), and add the needed line so it's in your path, e.g.:
export PATH=/opt/local/lib/postgresql90/bin/:$PATH
After having saved the file, read the file (. ~/.bash_profile) or open a new terminal, and type psql.
I'm on a Macbook Pro and wanted to get started with PostgreSQL.
However I'm confused on where to start.
I installed postgresql usin brew install postgresql and PSequal from http://www.psequel.com/
However, I have no idea what the hostname, port, username and password should be?
So how do I get started using PostgreSQL from here?