select open change scope Open full search

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

Extensions / Time series

recall

Tracks table changes in per-table _log tables for timestamp-based history queries.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_recall
Version0.9.6
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemarecall
Stars55
Latest commit2016-05-21
Latest release2016-05-21
Catalogue updated2026-08-30

Related extensions

Requires

btree_gistsupport for indexing common datatypes in GiST
plpgsqlPL/pgSQL procedural language

See also

pgmementoTransaction-based audit trail with schema versioning
fluxLogs table data changes and reconstructs rows as they existed in the past.
table_logrecord table modification logs and PITR for table/row
pg_auditAn extension for creating audit tables
istoriaTable history management with non-linear undo/redo
ddlaAudit DDL changes with event triggers and queryable log functions
pgauditprovides auditing functionality
tablelogTrigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL.