Postgres Pro
Downloads
Home   >   mailing lists

Re: Executing a shell command from a PG function - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Executing a shell command from a PG function
Date
Msg-id 20051210162215.GA42041@winnie.fuhr.org
Whole thread Raw
In response to Executing a shell command from a PG function  (Yves Vindevogel <yves.vindevogel@implements.be>)
Responses Re: Executing a shell command from a PG function
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Executing a shell command from a PG function
Next
From: Yves Vindevogel
Date:
Subject: Re: Executing a shell command from a PG function