Postgres Pro
Downloads
Home   >   mailing lists

Get affected table name in trigger function? - Mailing list pgsql-general

From Emi Lu
Subject Get affected table name in trigger function?
Date
Msg-id 43F0ECAE.1070508@encs.concordia.ca
Whole thread Raw
Responses Re: Get affected table name in trigger function?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Why does an ON SELECT rule have to be named "_RETURN"?
Next
From: Tom Lane
Date:
Subject: Re: Get affected table name in trigger function?