Bootcamp
Search…
3.4.8: SQL Clients

Introduction

We may have found that using psql to monitor DB changes can be tedious, because we need to run a query with raw SQL each time we wish to check our data.
SQL clients provide graphical user interfaces for us to monitor our data with clicks instead of typing queries. The SQL clients translate our clicks into queries under the hood, and typically we can also customise those queries if we need to.
There are many SQL clients to choose from, but Rocket recommends pgAdmin for Windows and Postico for Mac, both of which are free.

Windows

  1. 1.
    Launch Ubuntu in Windows.
  2. 2.
    Start postgres in Ubuntu terminal: sudo service postgresql
  3. 3.
    Download the latest pgAdmin and install in Windows.
  4. 4.
    Launch pgAdmin, a new tab in browser opens;
  5. 5.
    Click on Add New Server link.
  6. 6.
    In the popup Create - Server window in the browser: General tab: set Name to localhost
  7. 7.
    Connection tab: set Host name/address to 127.0.0.1
  8. 8.
    Set Password to postgres, which is the default
  9. 9.
    Click on Save password.

Mac

Download, install, and open Postico.

Alternatives

If we prefer a different interface we can try other Postgres SQL clients. They generally behave the same but with different user interfaces.