Check this article:
http://www.depesz.com/2012/06/13/how-to-send-mail-from-database/
2012/9/20 pavithra <pavithra(dot)ibt(at)gmail(dot)com>
> Hi All, I am new to postgresql. I want to send email by using pl pgsql. I
> want to know how to set up the configurations for mail server. Can any one
> help me in solving this?. [hidden email]<http://user/SendEmail.jtp?type=node&node=5724700&i=0>
>
--
Victor Y. Yegorov