Re: triggers - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: triggers
Date
Msg-id 200210181802.g9II2hi00535@candle.pha.pa.us
Whole thread Raw
In response to triggers  ("Stian Riis" <stian.riis@elineweb.com>)
List pgsql-sql
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
 


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: functions that return a dataset or set of rows
Next
From: Tom Lane
Date:
Subject: Re: Locking that will delayed a SELECT