Hi,

Is their equivalent to SQL Servers xp_cmdshell that can be called in plpsql
or plperl function?


Michael Godshall
GMAC Global Relocation <http://www.gmacglobalrelocation.com/> Services
900 So. Frontage Road
Woodridge, IL 60517
630-427-2070 office
630-972-2287 fax

michael_godshall (AT) gmachs (DOT) com <mailto:michael_godshall (AT) gmachs (DOT) com>

On Fri, Dec 19, 2003 at 05:10:53PM -0500, Godshall Michael wrote:
A response on the net at http://archives.postgresql.org/pgsql...7/msg00362.php says just :

QUOTE

That can only be done inside an untrusted procedural language. plpgsql is
trusted, so it can't do that type of thing.

C, pltclu, plprelu, and, as of 7.4 plpython will let you do that.

END QUOTE

My guess (only a guess) is that the call would then vary per language, so in C it might be int system(const char * cmdstring) and so on. I found on google http://www.varlena.com/varlena/GeneralBits/32.html referencing what a trusted language is.
--
joe speigle

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org