Re: Executing a shell command from a PG function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Executing a shell command from a PG function
Date: 2005-12-10 16:22:15
Message-ID: 20051210162215.GA42041@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Yves Vindevogel 2005-12-10 16:53:39 Re: Executing a shell command from a PG function
Previous Message Jaime Casanova 2005-12-10 16:14:14 Re: Executing a shell command from a PG function