Execution shell commands from Function

Started by Patrick Fichealmost 21 years ago2 messagesgeneral
Jump to latest
#1Patrick Fiche
patrick.fiche@aqsacom.com

Hi,

I made some tests of plsh with Postgresql 8.0.2 but it seems that it doesn't
work.
What's the easiest way to execute shell commands from a PostgreSQL function
(afraid not possible from pgsql function...).

Regards,
Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

#2Bricklen Anderson
banderson@presinet.com
In reply to: Patrick Fiche (#1)
Re: Execution shell commands from Function

Patrick.FICHE@AQSACOM.COM wrote:

Hi,

I made some tests of plsh with Postgresql 8.0.2 but it seems that it
doesn't work.
What's the easiest way to execute shell commands from a PostgreSQL
function (afraid not possible from pgsql function...).

Regards,
Patrick

Easiest way? No idea.
Another way to do it is to use plperlu.

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________