Re: How to process mail using pgSQL?

Hello

you have to find xp_sendmail.

PS

xp_sendmail
Sends a message and a query result set attachment to the specified
recipients.

Syntax
xp_sendmail {[(at)recipients =] 'recipients [;...n]'}
[,[(at)message =] 'message']
[,[(at)query =] 'query']
[,[(at)attachments =] 'attachments [;...n]']
[,[(at)copy_recipients =] 'copy_recipients [;...n]'
[,[(at)blind_copy_recipients =] 'blind_copy_recipients [;...n]'
[,[(at)subject =] 'subject']
[,[(at)type =] 'type']
[,[(at)attach_results =] 'attach_value']
[,[(at)no_output =] 'output_value']
[,[(at)no_header =] 'header_value']
[,[(at)width =] width]
[,[(at)separator =] 'separator']
[,[(at)echo_error =] 'echo_value']
[,[(at)set_user =] 'user']
[,[(at)dbuse =] 'database']