Auto mail sending using postgresql

[ttcplkavi]

hello..
Is anybody know how to do Auto mail sending using postgresql ..

Please reply asap

[michaelb]

I don't know what Auto mail is, but assuming you want to send email from Postgresql I can't think of an easy and natural way of doing that.

A not so natural approach could be to write a function using language which can execute a shell command, and then run something like sendmail, for example.

Perhaps it would help if you elaborate on what exactly you trying to accomplish and where you have your server (Windows, UNIX..?)