Perhaps this would work: http://sourceforge.net/projects/pgmail/
(I've never used it, just happened across it this weekend).
Cheers,
Steve
On Monday 20 January 2003 9:17 am, Berend Tober wrote:
> Is there a good way to make the database server send e-mail?
>
> I've been ask to work on a (Windows, client-server) application and
> implement a feature whereby duely authenticated and connected users can
> reset the password of other users without having to have DBA privileges.
> I've got that part working by using a stored procedure with the SECURITY
> DEFINER attribute (and the function is created by a DBA user) that calls
> ALTER USER...
>
> My next step is to have the database mail the new password to the reset
> user (the system uses e-mail addresses as usernames, so the database knows
> how to contact the user), along with the username of the person doing the
> resetting. I need help with suggestions on learning how to make the
> database server initiate an e-mail message.
>
>
> Regards,
> Berend Tober
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html