View on GitHub

psql-getting-started

A class offered through the Columbus State Community College Department of Workforce Development

Lab 2: Connect to PostGres via Gui

  1. Download and install the GUI version of Sqlectron.
  2. Open the Sqlectron application.
  3. Select the add button at the top of the application.
  4. In the form inside the modal enter the following values.
    1. Name: Local PostGres
    2. Type: PostGres
    3. Server Address: localhost
    4. User: postgres
    5. Password: See Lab 1
    6. Database: class
  5. Push the test button and confirm the configuration is correct.

    SQLectron

  6. Select the save button.
  7. At the servers screen select Local Postgres then select connect.
  8. Notice we can connect to the database and we are given a screen that lets us run SQL against the server.

Review

This lab was meant to install and familiarize