[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: show fct_name of the function/procedure
From:       "David G. Johnston" <david.g.johnston () gmail ! com>
Date:       2024-04-27 19:58:48
Message-ID: CAKFQuwaO5O--1sEpXhoXZx+XX4jVFLpDZjt1cH0ksLOf9D0UnQ () mail ! gmail ! com
[Download RAW message or body]

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.

[Attachment #3 (text/html)]

On Saturday, April 27, 2024, ft &lt;<a href="mailto:ml@ft-c.de">ml@ft-c.de</a>&gt; \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><br>  fct_name text := pg_fct_name()      ; --   I need \
it<br><br> </blockquote><div><br></div><div>  <a \
href="https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMEN \
TS-DIAGNOSTICS">https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQ \
L-STATEMENTS-DIAGNOSTICS</a></div><div><br></div><div>PG_ROUTINE_OID</div><div><br></div><div>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.</div><div><br></div><div><a \
href="https://www.postgresql.org/docs/current/datatype-oid.html">https://www.postgresql.org/docs/current/datatype-oid.html</a><br></div><div><br></div><div>David \
J.</div><div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]