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

From A. Kretschmer
Subject Re: ON INSERT => execute AWK/SH/EXE?
Date
Msg-id 20070918163334.GA18610@a-kretschmer.de
Whole thread Raw
In response to ON INSERT => execute AWK/SH/EXE?  ("Bima Djaloeis" <bima.djaloeis.uni@googlemail.com>)
Responses Re: ON INSERT => execute AWK/SH/EXE?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
am  Mon, dem 17.09.2007, um 18:50:46 +0200 mailte Bima Djaloeis folgendes:
> 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.

You can do this, you need a untrusted language like plperlU or plsh.
Then you can write a TRIGGER and call external programs.


Hope that helps, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Next
From: Erik Jones
Date:
Subject: Re: ON INSERT => execute AWK/SH/EXE?