> Hi all.
> I'd like to know if postgresql has the capability of execute
> external program with the trigger, for example, I had a trigger call
> "exceed_limit", when this trigger has fire, instead of update other
> relations, it will also execute a external program '/bin/send_email',
> is that possble ? If it's possible, can any of you guy please show
> me how to do it ? Thanks in advance.
Read Postgresql documentation: 21.4. Trusted and Untrusted PL/Perl.
Probably C functions have also ability for running system commands.
Regards,
Tomasz Myrta