Thread: xp_cmdshell equivalent

xp_cmdshell equivalent

From
Godshall Michael
Date:
Hi,
 
Is their equivalent to SQL Servers xp_cmdshell that can be called in plpsql or plperl function?
 

Michael Godshall
GMAC Global Relocation Services
900 So. Frontage Road
Woodridge, IL 60517
630-427-2070 office
630-972-2287 fax

michael_godshall@gmachs.com

 

Re: xp_cmdshell equivalent

From
joseph speigle
Date:
On Fri, Dec 19, 2003 at 05:10:53PM -0500, Godshall Michael wrote:
>
> Is their equivalent to SQL Servers xp_cmdshell that can be called in plpsql
> or plperl function?
>
> Michael Godshall

A response on the net at http://archives.postgresql.org/pgsql-sql/2003-07/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
languageis. 
--
joe speigle