Message-ID: <4e6435ceb793472cf52fdbd196f9d50c84469619.camel@ft-c.de>
Subject: show fct_name of the function/procedure
From: ft <ml@ft-c.de>
Reply-To: ml@ft-c.de
To: pgsql-general@lists.postgresql.org
Date: Sat, 27 Apr 2024 21:53:07 +0200
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4 FreeBSD GNOME Team
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/4e6435ceb793472cf52fdbd196f9d50c84469619.camel%40ft-c.de>
Precedence: bulk

Hello,=20

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

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

Franz