Re: running external programs

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: running external programs
Date: 2006-11-07 18:36:23
Message-ID: 20061107183623.GA31448@KanotixBox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

km <km(at)mrna(dot)tn(dot)nic(dot)in> schrieb:

>
> Hi all,
>
> Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ?

No, because plsql is a trusted language.
You can't run external commands from such a language.

>
> are there any workarounds for this sort of a problem ?

Yes, with untrusted languages like plperlU or plsh or other.

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°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-11-07 18:37:55 Re: database name aliases?
Previous Message Jeff Davis 2006-11-07 18:28:30 Re: EXECUTE INSERT BUGS?