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

-- Ищем процедуру которая создаёт документы автоматически
-- и одновременно создаёт payment
SELECT routine_name
FROM information_schema.routines
WHERE routine_schema = 'back_office'
  AND routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_definition ILIKE '%accrual_repurchase_amount_payments%'
  AND routine_definition ILIKE '%insert into back_office.payment%'
ORDER BY routine_name;