Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Get affected table name in trigger function?
Date
Msg-id 4380.1139863604@sss.pgh.pa.us
Whole thread Raw
In response to Get affected table name in trigger function?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
Emi Lu <emilu@encs.concordia.ca> writes:
> Is it possible to get current table name such as (TG_TABLENAME?) in a
> trigger function?

TG_RELNAME ... or look it up from the table OID TG_RELID ... or pass it
in as a trigger parameter ...

            regards, tom lane

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Get affected table name in trigger function?
Next
From: "Eric Chapdelaine"
Date:
Subject: Unhandled Exception - Executing Samples under win32