pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedExecuting a shell command from a PG function
4+ messages / 3 participants
[nested] [flat]
* Executing a shell command from a PG function
@ 2005-12-10 15:55 Yves Vindevogel <yves.vindevogel@implements.be>
2005-12-10 16:14 ` Re: Executing a shell command from a PG function Jaime Casanova <systemguards@gmail.com>
2005-12-10 16:22 ` Re: Executing a shell command from a PG function Michael Fuhr <mike@fuhr.org>
0 siblings, 2 replies; 4+ messages in thread
From: Yves Vindevogel @ 2005-12-10 15:55 UTC (permalink / raw)
To: pgsql-performance
Hi,
Is it possible to run a shell script, passing values of fields to it, in
a Postgres function ?
Yves Vindevogel
Attachments:
yves.vindevogel.vcf (text/x-vcard, 312B) download
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
* Re: Executing a shell command from a PG function
2005-12-10 15:55 Executing a shell command from a PG function Yves Vindevogel <yves.vindevogel@implements.be>
@ 2005-12-10 16:14 ` Jaime Casanova <systemguards@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jaime Casanova @ 2005-12-10 16:14 UTC (permalink / raw)
To: yves.vindevogel@implements.be; +Cc: pgsql-performance
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 ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Executing a shell command from a PG function
2005-12-10 15:55 Executing a shell command from a PG function Yves Vindevogel <yves.vindevogel@implements.be>
@ 2005-12-10 16:22 ` Michael Fuhr <mike@fuhr.org>
2005-12-10 16:53 ` Re: Executing a shell command from a PG function Yves Vindevogel <yves.vindevogel@implements.be>
1 sibling, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2005-12-10 16:22 UTC (permalink / raw)
To: Yves Vindevogel <yves.vindevogel@implements.be>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Executing a shell command from a PG function
2005-12-10 15:55 Executing a shell command from a PG function Yves Vindevogel <yves.vindevogel@implements.be>
2005-12-10 16:22 ` Re: Executing a shell command from a PG function Michael Fuhr <mike@fuhr.org>
@ 2005-12-10 16:53 ` Yves Vindevogel <yves.vindevogel@implements.be>
0 siblings, 0 replies; 4+ messages in thread
From: Yves Vindevogel @ 2005-12-10 16:53 UTC (permalink / raw)
To: 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/
>
>
>
Attachments:
yves.vindevogel.vcf (text/x-vcard, 312B) download
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
end of thread, other threads:[~2005-12-10 16:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-10 15:55 Executing a shell command from a PG function Yves Vindevogel <yves.vindevogel@implements.be>
2005-12-10 16:14 ` Jaime Casanova <systemguards@gmail.com>
2005-12-10 16:22 ` Michael Fuhr <mike@fuhr.org>
2005-12-10 16:53 ` Yves Vindevogel <yves.vindevogel@implements.be>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox