From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
---|---|
To: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
Cc: | Irawan Tanudirdjo <irwtan9(at)telkom(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to process mail using pgSQL? |
Date: | 2003-06-19 18:11:38 |
Message-ID: | Pine.LNX.4.44.0306192010000.25052-100000@kix.fsv.cvut.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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']
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-19 18:18:01 | Re: Performance differences using varchar, char and text |
Previous Message | Tom Lane | 2003-06-19 18:09:00 | Re: A creepy story about dates. How to prevent it? |