Re: Executing External Programs - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Executing External Programs
Date
Msg-id 20030517174323.GA22476@wolff.to
Whole thread Raw
In response to Executing External Programs  ("Andrew Brink" <abrink@netstandard.net>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: - what protocol for an Internet postgres
Next
From: "alex b."
Date:
Subject: query duration