select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Procedural languages

pgtap

Unit testing for PostgreSQL

pgext.cloud · Source code · Website · Control file · PGXN

Overview

Packagepgtap
Version1.3.4
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
Stars1,161
Latest commit2026-08-23
Latest release2025-10-04
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

Required by

basejump-supabase_test_helpersA collection of functions designed to make testing Supabase projects easier.
pg_thudFramework extending pgtap with scaffolding and test-data helpers for database unit tests.
pgsqlmockMocking and faking helpers for PostgreSQL unit tests
pgtap_fixtureA PostgreSQL extension that allows more complex fixtures to be created for pgTAP tests.
test_factory_pgtapA framework for managing test data
tg_sanity_tappgtap testing function for tg sanity triggers

See also

fakerWrapper for the Faker Python library
dbt2OSDL-DBT-2 test kit
pg_mockableCreate mockable wrappers for PostgreSQL functions in tests
pgsqlmockMocking and faking helpers for PostgreSQL unit tests
omni_testTesting framework
randomrandom data generator
tsm_system_timeTABLESAMPLE method which accepts time in milliseconds as a limit
tsm_system_rowsTABLESAMPLE method which accepts number of rows as a limit