[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] can trigger monitor two tables?
From:       Andreas Kretschmer <akretschmer () spamfence ! net>
Date:       2016-11-28 10:49:07
Message-ID: 20161128104907.GA8323 () tux
[Download RAW message or body]

zhangkai.gis <zhangkai.gis@163.com> wrote:

> Hello all,
>      I can monitor a table use triger write in language C as the example in
> postgres document .But I don't know whether or not can a trigger monitor more
> than one table?Is there a example?

i hope i understand you ...

you can use the same trigger-function for more than one table, but a
TRIGGER is per table, you have to define the trigger for every table.


Regards, Andreas Kretschmer
-- 
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]