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

From Scott Marlowe
Subject Re: ON INSERT => execute AWK/SH/EXE?
Date
Msg-id dcc563d10709180931n4e919288mc4e26223af8f36f@mail.gmail.com
Whole thread Raw
In response to ON INSERT => execute AWK/SH/EXE?  ("Bima Djaloeis" <bima.djaloeis.uni@googlemail.com>)
List pgsql-general
On 9/17/07, Bima Djaloeis <bima.djaloeis.uni@googlemail.com> 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.

Yes.  you have to use an untrusted pl language, like pl/perlu or
pl/tclu and you have to be a superuser to create user defined
functions in those languages.

pgsql-general by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Next
From: "A. Kretschmer"
Date:
Subject: Re: ON INSERT => execute AWK/SH/EXE?