Re: calling a shell script from pl/pgsql - Mailing list pgsql-sql

On Mon, 10 Sep 2001, Jeff Barrett wrote:

> How can I call a shell script from within a pl/pgsql function that is called
> as from a trigger. I do not want to interact with the script I just want it
> to run. I do want the trigger to wait for the script it called to complete
> before returning a value.
> 
> Any ideas would be greatly appreciated.

I don't think you can do that from within pl/pgsql.  You'd probably need a
function in pl/tclu or c.