SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:45 AM
| ||||
| ||||
 Executing a shell command from a PG function Hi, Is it possible to run a shell script, passing values of fields to it, in a Postgres function ? Yves Vindevogel ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-19-2008, 06:45 AM
| |||
| |||
| Re: Executing a shell command from a PG function 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  ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-19-2008, 06:45 AM
| |||
| |||
| Re: Executing a shell command from a PG function 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-19-2008, 06:45 AM
| ||||
| ||||
| Re: Executing a shell command from a PG function 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/ > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
