Thread: triggers

triggers

From
"Stian Riis"
Date:
Hi.

Does anyone know if it is posible to make a trigger that execute an
external program ? I want to execute a another program on the server
when I get a row in one of my tables...

-Stian



Re: triggers

From
Bruce Momjian
Date:
Stian Riis wrote:
> Hi.
> 
> Does anyone know if it is posible to make a trigger that execute an
> external program ? I want to execute a another program on the server
> when I get a row in one of my tables...

Yes, you can use plperl and call an external program from there, or us
plsh and run it that way.  plsh is mentioned on our web site under
interfaces.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073