Re: Runnning operating system commands from an SPL

Sorry I don't understand. I am porting over some stored procedures from
INFORMIX to POSTGRES. Some seem to port over OK, but the first problem I am
encountering is the lack of SYSTEM command in POSTGRES.

I don't understand what you mean by using an untrusted programming language.
The stored procedure is written in PL/pgSQL, are you suggesting to rewrite
it in PERL, excuse me for my ignorance.

Thanks

Atif

On 17 June 2010 15:51, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:

> Atif Jung <atifjung(at)gmail(dot)com> wrote:
>
> > How do I run an operating system command from a stored procedure? In
> INFORMIX I
> > would use the SYSTEM command, can't see to find the equivalent for
> POSTGRES.
>
> You can use a un-trusted programming language, for instance pl/perlu or
> plsh.
>
>
> 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." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>