Re: oid or schema name of current plpgsql function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Matko Andjelinic <mandjeli(at)mjesec(dot)ffzg(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: oid or schema name of current plpgsql function
Date: 2005-04-29 02:51:50
Message-ID: 20050429025150.GA68248@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-04-29 04:23:53 Re: Postgresql and VBA vs Python
Previous Message Ignatius Gabriell Rama S. 2005-04-29 02:23:52