Skip to content

Instantly share code, notes, and snippets.

@jhaber
Last active May 28, 2021 13:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jhaber/37162b7a7653693b6e0c9e5646285f4c to your computer and use it in GitHub Desktop.
Save jhaber/37162b7a7653693b6e0c9e5646285f4c to your computer and use it in GitHub Desktop.
  1. 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.

  1. Download and install PSequel.

  2. Open PSequel and click the Connect button (don't need to change any of the options) psequel

  3. You are now connected to your local instance of postgres and can start running queries by moving to the Query tab in PSequel.

  4. First you need to create a table, then you need to insert some data, and then you can start selecting data. queries

  5. You can also bulk load large amounts of data from a CSV file using the COPY command. copy

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment