---

SELECT
    t.tgname AS trigger_name,
    t.tgenabled AS enabled,
    n.nspname AS function_schema,
    p.proname AS function_name,
    pg_get_triggerdef(t.oid) AS trigger_definition
FROM pg_trigger t
JOIN pg_proc p
    ON p.oid = t.tgfoid
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE t.tgrelid =
      CAST('back_office.eps_transaction' AS regclass)
  AND NOT t.tgisinternal
ORDER BY t.tgname;