Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 549692E0381 for ; Thu, 6 Dec 2007 13:05:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 93608-04 for ; Thu, 6 Dec 2007 13:05:32 -0400 (AST) Received: from smtp156.iad.emailsrvr.com (smtp156.iad.emailsrvr.com [207.97.245.156]) by postgresql.org (Postfix) with ESMTP id 780A82E0267 for ; Thu, 6 Dec 2007 13:05:32 -0400 (AST) Received: from relay5.relay.iad.emailsrvr.com (localhost [127.0.0.1]) by relay5.relay.iad.emailsrvr.com (SMTP Server) with ESMTP id 820C8662292; Thu, 6 Dec 2007 12:05:31 -0500 (EST) Received: by relay5.relay.iad.emailsrvr.com (Authenticated sender: erik-AT-myemma.com) with ESMTP id 0CE5F668366; Thu, 6 Dec 2007 12:05:29 -0500 (EST) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.3) X-Priority: 3 Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: <0ADCABEF-24DC-4C72-9ED4-EBB7D2AA54FC@myemma.com> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable From: Erik Jones Subject: Re: execute system command from storage procedure Date: Thu, 6 Dec 2007 11:05:26 -0600 To: Sabin Coanda X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/18 X-Sequence-Number: 29710 On Dec 6, 2007, at 10:32 AM, Sabin Coanda wrote: > Hi there, > > Is it possible to execute a system command from a function ? (e.g. =20 > bash ) If you use one of the untrusted procedural languages (e.g. plperlu, =20 plpythonu, ...) you can. Erik Jones Software Developer | Emma=AE erik@myemma.com 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com