Saturday, October 24, 2026 4,350 lists 78,096 records on file
List your app or device

  1. Home
  2. Database Testing Tools
  3. pgTAP

pgTAP

On the record

Database behavior
Tests can exercise database views, procedures, functions, rules, and triggers.pgtap.org · read 2 Oct 2026
Database requirement
The package documentation says pgTAP requires PostgreSQL 9.1 or higher.pgxn.org · read 3 Oct 2026
Database testing
Its assertion functions can test database values and exercise views, procedures, functions, rules, and triggers.pgtap.org · read 3 Oct 2026
Hosting requirement
pgTAP must be installed on a host with PostgreSQL running and cannot be installed remotely.pgxn.org · read 3 Oct 2026
Installation
pgTAP must be installed on a host running PostgreSQL and cannot be installed remotely.pgxn.org · read 2 Oct 2026
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.pgtap.org · read 3 Oct 2026
Integrations
The integration guide describes running pgTAP tests with Perl's Test::Harness and TAP::Harness, and with PostgreSQL module testing tools.pgtap.org · read 3 Oct 2026
Latest listed release
PGXN lists pgTAP 1.3.4 as the stable release, dated 2025-10-04.pgxn.org · read 3 Oct 2026
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.pgxn.org · read 3 Oct 2026
PostgreSQL requirement
The release page says pgTAP requires PostgreSQL 9.1 or higher.pgxn.org · read 2 Oct 2026
Purpose
pgTAP is a PostgreSQL unit testing framework that emits TAP from psql scripts or xUnit style test functions.pgtap.org · read 3 Oct 2026
Schema testing
The framework includes functions for checking schema objects such as tables, columns, and primary keys.pgtap.org · read 3 Oct 2026
Support
The license says the author has no obligation to provide maintenance, support, updates, enhancements, or modifications.pgxn.org · read 2 Oct 2026
Support terms
The package license disclaims any obligation to provide maintenance, support, updates, enhancements, or modifications.pgxn.org · read 3 Oct 2026
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.pgtap.org · read 2 Oct 2026
Test output
pgTAP emits TAP output that can be collected and reported by a TAP harness.pgtap.org · read 2 Oct 2026
Test runner
pg_prove can run pgTAP tests and display TAP results.pgtap.org · read 3 Oct 2026
Test styles
pgTAP supports both scripting style tests and xUnit style tests, including setup and teardown functions for xUnit tests.pgtap.org · read 3 Oct 2026

Alternatives to pgTAP

Every alternative, ranked