Re: Executing External Programs

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrew Brink <abrink(at)netstandard(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Executing External Programs
Date: 2003-05-17 17:43:23
Message-ID: 20030517174323.GA22476@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 14, 2003 at 10:06:13 -0500,
Andrew Brink <abrink(at)netstandard(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message adeon 2003-05-17 17:59:46 How to deny user changing his own password?
Previous Message Nigel J. Andrews 2003-05-17 16:53:33 Re: - what protocol for an Internet postgres