select open change scope Open full search

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

Extensions / Security

ddla

Audit DDL changes with event triggers and queryable log functions

pgext.cloud · Source code · Documentation · Control file

Overview

Packageddla
Version0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2019-07-01
Catalogue updated2026-08-30

Related extensions

See also

pg_dbo_timestampPostgreSQL extension for storing time and author of database structure modification.
pgmementoTransaction-based audit trail with schema versioning
ddl_versioningDDL object versioning with event triggers for tables, indexes, functions, and views.
implicit_schemaEvent-trigger extension that automatically creates a schema when a table or view is created in a missing schema.
track_renamesEvent-trigger function that forwards PostgreSQL object rename details to a configurable callback.
schema_triggersArchived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.
verisqlAudit-grade verification gateway for AI-generated SQL — catches silently wrong queries before they hit your dashboard, keeps tamper-evident audit trails, verifies migration equivalence. Zero LLM tokens for 90% of checks.
pg_command_fwDDL and utility command firewall for PostgreSQL
ddl_replReplicate DDL and DCL commands across PostgreSQL instances by means of a utility hook
ddl_historizationHistorize the ddl changes inside PostgreSQL database