Re: Executing a shell command from a PG function

From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Executing a shell command from a PG function
Date: 2005-12-10 16:53:39
Message-ID: 439B0813.3020206@implements.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Attachment Content-Type Size
yves.vindevogel.vcf text/x-vcard 314 bytes

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-10 16:53:50 Re: Clustered tables and seqscan disabled
Previous Message Michael Fuhr 2005-12-10 16:22:15 Re: Executing a shell command from a PG function