Thread: Re: [GENERAL] ON INSERT => execute AWK/SH/EXE?
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
--- "A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote: > You can do this, you need a untrusted language like plperlU or plsh. > Then you can write a TRIGGER and call external programs. This may be a silly question, will plsh work on a windows server? I am pretty sure that plbat doesn't exist :-). Regards, Richard Broersma Jr.
am Tue, dem 18.09.2007, um 9:55:52 -0700 mailte Richard Broersma Jr folgendes: > --- "A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote: > > > You can do this, you need a untrusted language like plperlU or plsh. > > Then you can write a TRIGGER and call external programs. > > This may be a silly question, will plsh work on a windows server? I am pretty sure that plbat > doesn't exist :-). LOL ;-) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net