/ 
DBIO-PostgreSQL-0.900000
/ DBIO::PostgreSQL::Introspect::Triggers

NAME

DBIO::PostgreSQL::Introspect::Triggers - Introspect PostgreSQL triggers

VERSION

version 0.900000

DESCRIPTION

Fetches user-defined trigger metadata from pg_catalog.pg_trigger. Internal (constraint) triggers are excluded. Timing (BEFORE/AFTER/INSTEAD OF), event (INSERT/UPDATE/DELETE/TRUNCATE), and orientation (ROW/STATEMENT) are decoded from the tgtype bitmask.

METHODS

fetch

my $triggers = DBIO::PostgreSQL::Introspect::Triggers->fetch($dbh, $filter);

Returns a hashref keyed by schema.table. Each value is a hashref keyed by trigger name. Each trigger entry has: trigger_name, definition (from pg_get_triggerdef), timing, event, orientation, enabled.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.