Топ-100
 
CerebroSQL

PostgreSQL DB Event Triggers

The node displays information about created event triggers in the database  PostgreSQL , as well as detailed information about them

PostgreSQL event trigger list.jpg
Inquiry
Pane

select t.oid,
       t.evtevent,
       p.proname,
       t.evtname,
       p.oid "proc_oid",
       case evtenabled when 'O' then 'Origin'
                       when 'D' then 'Disabled'
                       when 'R' then 'Replica'
                       when 'A' then 'Always'
       end "Modes",
       pg_catalog.array_to_string(array(select x from pg_catalog.unnest(evttags) as t(x)), ', ') as "Tags",
       pg_catalog.obj_description(t.oid, 'pg_event_trigger') as "Description"
  from pg_catalog.pg_event_trigger t,
       pg_catalog.pg_proc p
where t.evtfoid = p.oid