---

SELECT
    t.tgname AS trigger_name,
    pg_get_triggerdef(t.oid, true) AS trigger_definition,
    p.proname AS function_name
FROM pg_catalog.pg_trigger t
JOIN pg_catalog.pg_class c
    ON c.oid = t.tgrelid
JOIN pg_catalog.pg_namespace n
    ON n.oid = c.relnamespace
JOIN pg_catalog.pg_proc p
    ON p.oid = t.tgfoid
WHERE n.nspname = 'ourpension'
  AND c.relname = 'contract_params'
  AND NOT t.tgisinternal
ORDER BY t.tgname;