show fct_name of the function/procedure

From: ft <ml(at)ft-c(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: show fct_name of the function/procedure
Date: 2024-04-27 19:53:07
Message-ID: 4e6435ceb793472cf52fdbd196f9d50c84469619.camel@ft-c.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I need (a very simple construct) to show the fct_name/proc_name 
for the function/procedure.

Example:
create procedure/function bet_process() as
$$
declare
pid int := pg_backend_pid() ; -- it works fine
fct_name text := pg_fct_name() ; -- I need it
begin
-- do s.th like
-- call log(pid, fct_name, 'my message');
end;
$$ language plpgsql;

Franz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-04-27 20:01:30 Re: show fct_name of the function/procedure
Previous Message Sasmit Utkarsh 2024-04-27 19:23:03 Re: Stess test via libpq for postgreSQL DB