Re: oid or schema name of current plpgsql function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: oid or schema name of current plpgsql function
Date
Msg-id 20050429025150.GA68248@winnie.fuhr.org
Whole thread Raw
In response to oid or schema name of current plpgsql function  (mandjeli@mjesec.ffzg.hr (Matko Andjelinic))
Responses Re: oid or schema name of current plpgsql function
List pgsql-general
On Thu, Apr 28, 2005 at 10:37:47PM +0200, Matko Andjelinic wrote:
>
> Is there a way to know the OID of the current plpgsql function from
> inside the function?

I'm not aware of a way to get the current function's OID in PL/pgSQL,
but you can do it in C.

> What I really need is to extract the name of the schema where the
> function is stored.

Why do you need to know the function's schema?  What are you trying
to do?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Ignatius Gabriell Rama S."
Date:
Subject:
Next
From: John DeSoi
Date:
Subject: Re: Postgresql and VBA vs Python