CS 374: Database Systems
James Madison University, Spring 2022

Feb 15: PostgreSQL, pgAdmin, and psql

Lesson Outline

30 min Lecture Slides
* Demo of pgAdmin
* LIKE queries (% / _)
* Connecting off campus
20 min Install Fest!
* psqldon't install the server!
* meld – add to PATH if needed
25 min HW4 Overview
* SQL style guide
* How to use less
* How to use psql

Before Thursday

  1. Textbook: Read PDBM 7.3--7.3.1.4 (9 pages).

  2. Homework: Start work on HW4 (due in two weeks).

  3. Project: Start work on GP2 (gater data, write DDL).