show fct_name of the function/procedure

Started by ftalmost 2 years ago2 messagesgeneral
Jump to latest
#1ft
ml@ft-c.de

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

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: ft (#1)
Re: show fct_name of the function/procedure

On Saturday, April 27, 2024, ft <ml@ft-c.de> wrote:

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

https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

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.

https://www.postgresql.org/docs/current/datatype-oid.html

David J.