pgTAP is a unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL. It includes a comprehensive collection of TAP-emitting assertion functions, as well as the ability to integrate with other TAP-emitting test frameworks. It can also be used in the xUnit testing style.

Usage

References and Resources

pgtap official repository (opens new window)

pgtap official documentation (opens new window)

ANNEXE - Installing pgtap on OpenBSD

ftp https://github.com/theory/pgtap/archive/refs/tags/v1.3.1.tar.gz
tar zxvf v1.3.1.tar.gz
cd pgtap-1.3.1
gmake
doas gmake install