By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

access linux command from SQL Query

P: n/a
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 ?

thanks
regards,

Alam Surya
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
ma*****@mascari.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.