Thread: execute system command from storage procedure

execute system command from storage procedure

From
"Sabin Coanda"
Date:
Hi there,

Is it possible to execute a system command from a function ? (e.g. bash )

TIA,
Sabin 




Re: execute system command from storage procedure

From
Erik Jones
Date:
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




Re: execute system command from storage procedure

From
Andreas Kretschmer
Date:
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°