Get affected table name in trigger function?

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Get affected table name in trigger function?
Date: 2006-02-13 20:31:42
Message-ID: 43F0ECAE.1070508@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is it possible to get current table name such as (TG_TABLENAME?) in a
trigger function?

For example, tables t1, t2, t3 all depend on one trigger function. In
the trigger function, is it possible to get the current affected table
name - is it t1, t2 or t3 ?

Thanks a lot,
Emi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-13 20:46:44 Re: Get affected table name in trigger function?
Previous Message Stephan Szabo 2006-02-13 19:43:23 Re: Why does an ON SELECT rule have to be named "_RETURN"?