On Saturday, April 27, 2024, ft 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
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
-
