X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 200D59DCBCF for ; Sat, 10 Dec 2005 12:50:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87388-05 for ; Sat, 10 Dec 2005 12:50:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hoboe1bl1.telenet-ops.be (hoboe1bl1.telenet-ops.be [195.130.137.72]) by postgresql.org (Postfix) with ESMTP id B323C9DCAAD for ; Sat, 10 Dec 2005 12:50:51 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hoboe1bl1.telenet-ops.be (Postfix) with SMTP id 4621A38316 for ; Sat, 10 Dec 2005 17:50:48 +0100 (CET) Received: from [10.0.1.5] (d5152B3BA.access.telenet.be [81.82.179.186]) by hoboe1bl1.telenet-ops.be (Postfix) with ESMTP id 23B823830D for ; Sat, 10 Dec 2005 17:50:48 +0100 (CET) Message-ID: <439B0813.3020206@implements.be> Date: Sat, 10 Dec 2005 17:53:39 +0100 From: Yves Vindevogel Reply-To: yves.vindevogel@implements.be User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Executing a shell command from a PG function References: <439AFA8C.5070303@implements.be> <20051210162215.GA42041@winnie.fuhr.org> In-Reply-To: <20051210162215.GA42041@winnie.fuhr.org> Content-Type: multipart/mixed; boundary="------------020309030105090800080905" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.823 required=5 tests=[RCVD_IN_SORBS_SOCKS=1.823] X-Spam-Score: 1.823 X-Spam-Level: * X-Archive-Number: 200512/271 X-Sequence-Number: 16092 This is a multi-part message in MIME format. --------------020309030105090800080905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/ > > > --------------020309030105090800080905 Content-Type: text/x-vcard; charset=utf-8; name="yves.vindevogel.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="yves.vindevogel.vcf" begin:vcard fn:Yves Vindevogel n:Vindevogel;Yves org:Implements adr:;;Kempische Steenweg 206;Hasselt;;3500;Belgium email;internet:yves.vindevogel@implements.be tel;work:+32 (11) 43 55 76 tel;home:+32 (11) 43 55 76 tel;cell:+32 (478) 80 82 91 x-mozilla-html:TRUE url:http://www.implements.be version:2.1 end:vcard --------------020309030105090800080905--