select open change scope Open full search

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

Extensions / Administration

pg_drop_events

logs transaction ids of drop table, drop column, drop materialized view statements

pgext.cloud · Source code · Control file · PGXN

Overview

Packagepg_drop_events
Version0.1.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapublic
Stars7
Latest commit2025-01-18
Latest release2025-01-18
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

table_logrecord table modification logs and PITR for table/row
safeupdateRequire criteria for UPDATE and DELETE
pg_strictPrevent dangerous UPDATE and DELETE without WHERE clause
pg_saviorPostgres extension to save OOPS mistakes
pgmementoTransaction-based audit trail with schema versioning
pgauditprovides auditing functionality
pgelogExtended logging via pseudo-autonomous transactions
block_copy_commandBlock COPY commands via a configurable ProcessUtility hook
pg_kpartReject full partition scans that omit the partition key
data_historizationPLPGSQL Script to historize data in partitionned table