| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-09-18 16:33:44 | Re: ON INSERT => execute AWK/SH/EXE? |
| Previous Message | Scott Marlowe | 2007-09-18 16:31:41 | Re: ON INSERT => execute AWK/SH/EXE? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-09-18 16:33:44 | Re: ON INSERT => execute AWK/SH/EXE? |
| Previous Message | Scott Marlowe | 2007-09-18 16:31:41 | Re: ON INSERT => execute AWK/SH/EXE? |