Skip to content
SPECIFICTION
Get listed

pgTAP

pgtap.org

LinuxSelf-hosted
Visit pgtap.org
Spec score 6.9 #25 of 28 in Database Testing Tools

Spec sheet

Purpose
pgTAP is a PostgreSQL unit testing framework that emits TAP from psql scripts or xUnit style test functions.Read 3 Oct 2026 · pgtap.org
Integrations
The integration guide describes running pgTAP tests with Perl's Test::Harness and TAP::Harness, and with PostgreSQL module testing tools.Read 3 Oct 2026 · pgtap.org
Support
The license says the author has no obligation to provide maintenance, support, updates, enhancements, or modifications.Read 2 Oct 2026 · pgxn.org
License
The PGXN package page grants permission to use, copy, modify, and distribute pgTAP and its documentation without a fee, subject to the stated conditions.Read 3 Oct 2026 · pgxn.org
Database behavior
Tests can exercise database views, procedures, functions, rules, and triggers.Read 2 Oct 2026 · pgtap.org
Database requirement
The package documentation says pgTAP requires PostgreSQL 9.1 or higher.Read 3 Oct 2026 · pgxn.org
Database testing
Its assertion functions can test database values and exercise views, procedures, functions, rules, and triggers.Read 3 Oct 2026 · pgtap.org
Hosting requirement
pgTAP must be installed on a host with PostgreSQL running and cannot be installed remotely.Read 3 Oct 2026 · pgxn.org
Installation
pgTAP must be installed on a host running PostgreSQL and cannot be installed remotely.Read 2 Oct 2026 · pgxn.org
Integration guidance
The integration page mentions PHP and Python testing frameworks but says users should send instructions for those integrations to the project's mailing list.Read 3 Oct 2026 · pgtap.org
Latest listed release
PGXN lists pgTAP 1.3.4 as the stable release, dated 2025-10-04.Read 3 Oct 2026 · pgxn.org
PostgreSQL requirement
The release page says pgTAP requires PostgreSQL 9.1 or higher.Read 2 Oct 2026 · pgxn.org
Schema testing
The framework includes functions for checking schema objects such as tables, columns, and primary keys.Read 3 Oct 2026 · pgtap.org
Support terms
The package license disclaims any obligation to provide maintenance, support, updates, enhancements, or modifications.Read 3 Oct 2026 · pgxn.org
Test isolation
The xUnit-style runtests() function rolls back changes made to the schema during each test and supports setup, teardown, startup, and shutdown functions.Read 2 Oct 2026 · pgtap.org
Test output
pgTAP emits TAP output that can be collected and reported by a TAP harness.Read 2 Oct 2026 · pgtap.org
Test runner
pg_prove can run pgTAP tests and display TAP results.Read 3 Oct 2026 · pgtap.org
Test styles
pgTAP supports both scripting style tests and xUnit style tests, including setup and teardown functions for xUnit tests.Read 3 Oct 2026 · pgtap.org

Where Specifiction places it

Alternatives to pgTAPAll alternatives →