Загрузка данных


SELECT
    n.nspname AS schema_name,
    p.proname AS routine_name,
    pg_get_functiondef(p.oid) AS definition
FROM pg_proc p
JOIN pg_namespace n ON n.oid = p.pronamespace
WHERE p.prokind IN ('f', 'p')
  AND p.prosrc ILIKE '%eps_transaction%'
  AND (
      p.prosrc ILIKE '%pens_schema_dt%'
      OR p.prosrc ILIKE '%pens_schema_ct%'
  )
  AND p.proname <> 'get_eps_moving';