Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group