Re: ON INSERT => execute AWK/SH/EXE? - Mailing list pgsql-general

From Erik Jones
Subject Re: ON INSERT => execute AWK/SH/EXE?
Date
Msg-id 3CB6C4A5-0FAB-4E32-9491-1CF7806A81C4@myemma.com
Whole thread Raw
In response to ON INSERT => execute AWK/SH/EXE?  ("Bima Djaloeis" <bima.djaloeis.uni@googlemail.com>)
List pgsql-general
On Sep 17, 2007, at 11:50 AM, Bima Djaloeis wrote:

> Hi there,
>
> I am new to PostgreSQL, is it possible to create something so that
>
> 1) If I insert / update / delete an item from my DB...
> 2) ... an awk / shell / external program is executed in my UNIX
> System?
>
> If yes, how do I do this and if no, thanks for telling.
>
> Thanks for reading, any help is appreciated.

You could use a trigger function in an untrusted procedural language
such as plperlu or plpythonu to do that.

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Next
From: Steve Crawford
Date:
Subject: Optimizing "exists"