Thread: Executing a shell command from a PG function

Hi,

Is it possible to run a shell script, passing values of fields to it, in
a Postgres function ?

Yves Vindevogel

On 12/10/05, Yves Vindevogel <yves.vindevogel@implements.be> wrote:
> Hi,
>
> Is it possible to run a shell script, passing values of fields to it, in
> a Postgres function ?
>
> Yves Vindevogel
>

search for the pl/sh language

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

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

Thanks Michael and Jaime.  The pg/sh thing is probably what I was
looking for.
Tnx


Michael Fuhr wrote:

>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/
>
>
>