Обсуждение: Question regardding info available in customer C trigger function

I've been scouring the docs, but have not come up with answers for
all my questions.

I found out how to deal with trigger function arguments via PG_GETARG_xxx.

However, is there a way in my C function to determine the name of the
table and of the database that caused the trigger.  This trigger will
be used in several tables in several databases, and while I could pass
these names as parameters, it would be much easier to be able to determine
this via the context when called.

Any info would be greatly appreciated.

-- Curt

Curtis H. Wilbar Jr.
Hawk Mountain Networks
curtis@hawkmountain.net

"Curtis H. Wilbar Jr." <curtis@hawkmountain.net> writes:
> However, is there a way in my C function to determine the name of the
> table and of the database that caused the trigger.

The current database name is not passed around as a parameter, but you
can get it from the global variable DatabaseName.  As for the table
name, try RelationGetRelationName(triggerdata->tg_relation).

            regards, tom lane