Home > mailing lists

Re: show fct_name of the function/procedure - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: show fct_name of the function/procedure
Date	April 27 23:01:30
Msg-id	CAKFQuwaO5O--1sEpXhoXZx+XX4jVFLpDZjt1cH0ksLOf9D0UnQ@mail.gmail.com Whole thread Raw
In response to	show fct_name of the function/procedure (ft <ml@ft-c.de>)
List	pgsql-general

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

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

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.

David J.

From: ft
Date: 27 April, 22:53:07
Subject: show fct_name of the function/procedure

From: Ayush Vatsa
Date: 28 April, 16:01:05
Subject: Query Discrepancy in Postgres HLL Test