Contents

select  event_object_schema as table_schema,
        event_object_table as table_name,
        trigger_schema,
        trigger_name,
        string_agg(event_manipulation, ',') as event,
        action_timing as activation,
        action_condition as condition,
        action_statement as definition
from    information_schema.triggers
group by 
        1,2,3,4,6,7,8
order by 
        table_schema,
        table_name;

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
postspec-0.5.5	snippets/triggers.sql
postspec-0.5.4	snippets/triggers.sql
postspec-0.5.3	snippets/triggers.sql
postspec-0.5.2	snippets/triggers.sql
postspec-0.5.1	snippets/triggers.sql
postspec-0.5.0	snippets/triggers.sql
postspec-0.4.1	snippets/triggers.sql
postspec-0.4.0	snippets/triggers.sql
postspec-0.2.5	snippets/triggers.sql
postspec-0.2.4	snippets/triggers.sql
postspec-0.2.3	snippets/triggers.sql
postspec-0.2.2	snippets/triggers.sql
postspec-0.2.1	snippets/triggers.sql
postspec-0.2.0	snippets/triggers.sql
postspec-0.1.2	snippets/triggers.sql
postspec-0.1.1	snippets/triggers.sql