- Run these commands in terminal:
brew install postgres
postgres -D /usr/local/var/postgresYou now have postgres running locally and listening on port 5432.
-
Download and install PSequel.
-
Open PSequel and click the
Connectbutton (don't need to change any of the options) -
You are now connected to your local instance of postgres and can start running queries by moving to the
Querytab in PSequel. -
First you need to create a table, then you need to insert some data, and then you can start selecting data.
-
You can also bulk load large amounts of data from a CSV file using the
COPYcommand.


