Re: Executing a shell command from a PG function

On Sat, Dec 10, 2005 at 04:55:56PM +0100, Yves Vindevogel wrote:
> Is it possible to run a shell script, passing values of fields to it, in
> a Postgres function ?

Not directly from SQL or PL/pgSQL functions, but you can execute
shell commands with the untrusted versions of PL/Perl, PL/Tcl,
PL/Python, etc.  There's even a PL/sh:

http://pgfoundry.org/projects/plsh/

--
Michael Fuhr