On Mon, Feb 14, 2005 at 07:32:15PM +1100, John Hansen wrote: > > Is there a way for a C function to determine the name of the > schema in which is was created?
Dunno if there's anything as simple as whats_my_schema(), but fcinfo->flinfo->fn_oid should contain the function's oid. If nobody mentions an easier way, you could use SPI to query pg_proc and pg_namespace. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]