Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: yves.vindevogel.vcf
Description: text/x-vcard (314 bytes)

In response to

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group