Thread: invoke an external shell script from a function

Does anyone know how to invoke an external shell script from a function when
it is called from a sql statement?

-- Artemis Chau, Intel Corp.

Chau, Artemis writes:

> Does anyone know how to invoke an external shell script from a function when
> it is called from a sql statement?

If it's a C function, use system("file").

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Peter Eisentraut wrote:
> 
> Chau, Artemis writes:
> 
> > Does anyone know how to invoke an external shell script from a function when
> > it is called from a sql statement?
> 
> If it's a C function, use system("file").

Is this the only way to do this?  I would also like to have a trigger
call an external program.  Is there a good place to go for more info on
this?

TIA