Node EVENT TRIGGERS for PostgreSQL
[EN]
The node displays information about created event triggers in the PostgreSQL database, as well as detailed information about them
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
[RU]
Узел отображает информацию созданных событийных триггерах в базе данных PostgreSQL, а так же подробную информацию о них
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