In your command-line run the following commands:
brew doctorbrew update
EileenJuergens
/ postgres-brew.md
Created
May 2, 2020 11:49
— forked from ibraheem4/postgres-brew.md
Installing Postgres via Brew (OSX)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| psql -U postgres // start postgres shell or command line interface. | |
| Some interesting flags (to see all, use -h or --help depending on your psql version): | |
| -E: will describe the underlaying queries of the \ commands (cool for learning!) | |
| -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS) | |
| Most \d commands support additional param of __schema__.name__ and accept wildcards like *.* | |
| \q: Quit/Exit | |
| \l list all the databases | |
| \c __database__: Connect to a database |