Re: access linux command from SQL Query - Mailing list pgsql-general

From Mike Mascari
Subject Re: access linux command from SQL Query
Date
Msg-id 3FA896A6.7040805@mascari.com
Whole thread Raw
In response to access linux command from SQL Query  ("Alam Surya" <alam_it@csahome.com>)
List pgsql-general
Alam Surya wrote:

> hello all......
>
> I have a litle question, do i have acces linux command from postgresql
> query like send message to others linux user in LAN ? any feature for that ?

You could use a system() call in a C function, or you could use Peter
Eisentraut's pl/sh language:

http://webmail.postgresql.org/~petere/plsh.html

Of course, if you use trigger functions to send email messages you
lose transactional integrity with respect to the underlying data vs.
the email message in the face of a transaction abort. Therefore some
people do this in middleware after the transaction associated with the
email message has been committed.

Hope that helps,

Mike Mascari
mascarm@mascari.com



pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Changes in Rel. 7.4
Next
From: "Jaime Casanova"
Date:
Subject: Re: Database design question: ugliness or referential integrity?