- Run these commands in terminal:
brew install postgres
postgres -D /usr/local/var/postgres
You now have postgres running locally and listening on port 5432.
-
Download and install PSequel.
-
Open PSequel and click the
Connect
button (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
Query
tab 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
COPY
command.