Re: show fct_name of the function/procedure

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Saturday, April 27, 2024, ft <ml@xxxxxxx> 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.