Re: Run external program on a trigger? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Run external program on a trigger?
Date
Msg-id 200501201412.01494.peter_e@gmx.net
Whole thread Raw
In response to Run external program on a trigger?  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: [HACKERS] Postgres 8.1.x and MIT Kerberos 5
Next
From: Tom Lane
Date:
Subject: Re: Online Backup and WAL archives