pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedexecute system command from storage procedure
3+ messages / 3 participants
[nested] [flat]
* execute system command from storage procedure
@ 2007-12-06 16:32 Sabin Coanda <sabin.coanda@deuromedia.ro>
0 siblings, 2 replies; 3+ messages in thread
From: Sabin Coanda @ 2007-12-06 16:32 UTC (permalink / raw)
To: pgsql-sql
Hi there,
Is it possible to execute a system command from a function ? (e.g. bash )
TIA,
Sabin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: execute system command from storage procedure
@ 2007-12-06 17:05 Erik Jones <erik@myemma.com>
parent: Sabin Coanda <sabin.coanda@deuromedia.ro>
1 sibling, 0 replies; 3+ messages in thread
From: Erik Jones @ 2007-12-06 17:05 UTC (permalink / raw)
To: Sabin Coanda <sabin.coanda@deuromedia.ro>; +Cc: pgsql-sql
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.
> bash )
If you use one of the untrusted procedural languages (e.g. plperlu,
plpythonu, ...) you can.
Erik Jones
Software Developer | Emma®
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: execute system command from storage procedure
@ 2007-12-06 17:07 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Sabin Coanda <sabin.coanda@deuromedia.ro>
1 sibling, 0 replies; 3+ messages in thread
From: Andreas Kretschmer @ 2007-12-06 17:07 UTC (permalink / raw)
To: pgsql-sql
Sabin Coanda <sabin.coanda@deuromedia.ro> schrieb:
> Hi there,
>
> Is it possible to execute a system command from a function ? (e.g. bash )
Yes, of course, but you need an untrusted language like pl/perlU oder
plsh. http://plsh.projects.postgresql.org/
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-12-06 17:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-06 16:32 execute system command from storage procedure Sabin Coanda <sabin.coanda@deuromedia.ro>
2007-12-06 17:05 ` Erik Jones <erik@myemma.com>
2007-12-06 17:07 ` Andreas Kretschmer <akretschmer@spamfence.net>
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