MIME-Version: 1.0
In-Reply-To: <4e6435ceb793472cf52fdbd196f9d50c84469619.camel@ft-c.de>
References: <4e6435ceb793472cf52fdbd196f9d50c84469619.camel@ft-c.de>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 27 Apr 2024 13:01:30 -0700
Message-ID: <CAKFQuwaO5O--1sEpXhoXZx+XX4jVFLpDZjt1cH0ksLOf9D0UnQ@mail.gmail.com>
Subject: Re: show fct_name of the function/procedure
To: "ml@ft-c.de" <ml@ft-c.de>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000082fa550617197c11"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaO5O--1sEpXhoXZx%2BXX4jVFLpDZjt1cH0ksLOf9D0UnQ%40mail.gmail.com>
Precedence: bulk

--00000000000082fa550617197c11
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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

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

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

PG_ROUTINE_OID

I think casting that to =E2=80=9Cregproc=E2=80=9D will get you what you nee=
d.  Otherwise
there should be functions or a query to perform the needed lookup.

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

David J.

--00000000000082fa550617197c11
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, April 27, 2024, ft &lt;<a href=3D"mailto:ml@ft-c.de">ml@ft-c.d=
e</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
=C2=A0fct_name text :=3D pg_fct_name()=C2=A0 =C2=A0 ; --=C2=A0 I need it<br=
><br>
</blockquote><div><br></div><div>=C2=A0<a href=3D"https://www.postgresql.or=
g/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS">http=
s://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEME=
NTS-DIAGNOSTICS</a></div><div><br></div><div>PG_ROUTINE_OID</div><div><br><=
/div><div>I think casting that to =E2=80=9Cregproc=E2=80=9D will get you wh=
at you need.=C2=A0 Otherwise there should be functions or a query to perfor=
m the needed lookup.</div><div><br></div><div><a href=3D"https://www.postgr=
esql.org/docs/current/datatype-oid.html">https://www.postgresql.org/docs/cu=
rrent/datatype-oid.html</a><br></div><div><br></div><div>David J.</div><div=
><br></div>

--00000000000082fa550617197c11--