pg_test_table_track: PostgreSQL Unit Tests Table Cleanup Extension

A PostgreSQL extension to efficiently cleanup database in-between test runs.

[!INFO]

I also created a blog post which can be found here. The slides are also published at pgday.dogac.dev Presented at PGDay Chicago 2025.

Installation

Prerequisites

• PostgreSQL installed (pg_config should be available)
• Git installed

If postgreSQL is installed locally,

curl -sSL https://raw.githubusercontent.com/dogacel/pg_test_table_track/main/install.sh | bash

If postgreSQL is installed inside a docker container,

curl -sSL https://raw.githubusercontent.com/dogacel/pg_test_table_track/main/install_docker.sh | bash -s $DB_CONTAINER_NAME $DB_NAME $POSGRES_USER