Re: Run external program on a trigger?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)askesis(dot)nl>
Cc: "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Run external program on a trigger?
Date: 2005-01-20 13:12:01
Message-ID: 200501201412.01494.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-01-20 13:41:56 Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?
Previous Message Troyston Campano 2005-01-20 13:03:42 Re: Oracle and Postgresql Play Nice Together on Same Computer?