On Wed, May 14, 2003 at 10:06:13 -0500,
Andrew Brink <abrink@netstandard.net> wrote:
>
>
> Is there a way (maybe creating a function) to execute an external program from within postgre with a query?
You can do this in c and probably untrusted perl.
It may not be the best way to handle things depending on what you are
doing. This is especially true if you were planning on waiting for the
program to complete before returning from the function.
In many cases having a program poll (or run from cron) and check for
work to do is a better way to do this.