Re: finding schema of table that called a trigger - Mailing list pgsql-sql

From Richard Huxton
Subject Re: finding schema of table that called a trigger
Date
Msg-id 4235495A.5020800@archonet.com
Whole thread Raw
In response to finding schema of table that called a trigger  (Jeff Hoffmann <jeff@propertykey.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: sql: "LIKE" problem
Next
From: Ragnar Hafstað
Date:
Subject: Re: How to cast VARCHAR to BYTEA and vice-versa?