Re: Run external program on a trigger?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Run external program on a trigger?

Peter Eisentraut-2
Joost Kraaijeveld wrote:
> Is it possible to run an arbitrary external program on my Linux
> machine if a trigger fires?

Sure, just have the trigger procedure call the external program.  The
untrusted languages can do that, or if you want to go barebones, try
PL/sh (http://developer.postgresql.org/~petere/pgplsh/)/

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org