PgExercises is a sample dataset used to power the PostgreSQL Exercises website. The site is comprised of over 80 exercises designed to be used as a companion to the official PostgreSQL documentation. The exercises on the PGExercises site range from simple SELECT statements and WHERE clauses, through JOINs and CASE statements, then on to aggregations, window functions, and recursive queries.
The dataset consists of 3 tables (members, bookings, and facilities) and table relationships as shown in the ER diagram below:
In this post we are going to walk you through how to download and install PGExercises on the YugabyteDB distributed SQL database with a replication factor of 3.