Re: Can I call unix/linux commands within plsql?

Missed the first post, and take what Stephen says as important regarding
transactions ,etc... but here's a link to a unix shell language handler
for postgres.

http://www.ca.postgresql.org/~petere/plsh.html

Never used it myself, but there it is.

I've also seen (maybe in contrib? maybe somewhere else) a sendmail
function (in C) that allows you to send email from within plsql. If you
search the archives you'll find it.

-philip

On Thu, 13 Dec 2001, Stephan Szabo wrote:

>
> On Thu, 13 Dec 2001, [big5] Timmy HK wrote:
>
> > Hello,
> >
> > I'm new to Postgresql/plsql. Can anyone tell me that whether I can
> > call unix/linux commands within plsql or not? I need it because some
> > functions can not be provided by the PostgreSQL server itself such as
> > email.
>
> Not directly. You can do this from C, but you need to be careful,
> because anything you do outside of the database is not transaction
> safe (ie, if something rolls back the transaction after the function
> is called, the outside things are still done even though any data
> changes are not recorded).
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>