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


select ourpension.f_create_snv_incoming_tessa(
    null::text,
    null::text,
    null::bigint,
    1::integer
);




select pg_get_functiondef(
    'ourpension.f_create_snv_incoming_tessa(text,text,bigint,integer)'::regprocedure
);



select p.oid::regprocedure
from pg_proc p
join pg_namespace n
    on n.oid = p.pronamespace
where n.nspname = 'ourpension'
  and p.proname = 'f_create_snv_incoming_tessa';