On Fri, Jun 03, 2005 at 20:56:44 +0200,
Gevik babakhani <gevik(at)xs4all(dot)nl> wrote:
> Dear people,
>
>
>
> Does anyone know how to execute an OS command from pgsql. I would like to
> create a trigger that op on firing would run/execute an external program.
>
> Does such functionality exist or do I have to write my own trigger function
> in C.
You would have to write your own trigger, though you could use other languages
than C (e.g. untrusted perl).
Another option is to communicate with an external program using notify.