Обсуждение: show fct_name of the function/procedure

Поиск
Список
Период
Сортировка

show fct_name of the function/procedure

От
ft
Дата:
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




Re: show fct_name of the function/procedure

От
"David G. Johnston"
Дата:
On Saturday, April 27, 2024, ft <ml@ft-c.de> wrote:

 fct_name text := pg_fct_name()    ; --  I need it



PG_ROUTINE_OID

I think casting that to “regproc” will get you what you need.  Otherwise there should be functions or a query to perform the needed lookup.


David J.