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

Re: ON INSERT => execute AWK/SH/EXE?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Date: 2007-09-18 16:33:34
Message-ID: 20070918163334.GA18610@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Erik JonesDate: 2007-09-18 16:33:44
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Previous:From: Scott MarloweDate: 2007-09-18 16:31:41
Subject: Re: ON INSERT => execute AWK/SH/EXE?

pgsql-general by date

Next:From: Erik JonesDate: 2007-09-18 16:33:44
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Previous:From: Scott MarloweDate: 2007-09-18 16:31:41
Subject: Re: ON INSERT => execute AWK/SH/EXE?

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