Thread: finding schema of table that called a trigger

finding schema of table that called a trigger

From
Jeff Hoffmann
Date:
Is there a variable defined that has the schema of the table that called 
the trigger (like TG_RELNAME = table name)?  I didn't see anything in 
the documentation.  Is the only way to get that to look it up with TG_RELID?

-- 
Jeff Hoffmann
jeff@propertykey.com


Re: finding schema of table that called a trigger

From
Richard Huxton
Date:
Jeff Hoffmann wrote:
> Is there a variable defined that has the schema of the table that called 
> the trigger (like TG_RELNAME = table name)?  I didn't see anything in 
> the documentation.  Is the only way to get that to look it up with 
> TG_RELID?

I must admit I don't know of one. Hmm - it would obviously be simple 
enough to add to the interface, but I presume there is some overhead for 
each parameter you supply.

--   Richard Huxton  Archonet Ltd