Send email when new record inserted

Hi,

This may seem a trivial task, but im stumped. When a new record is inserted
in one of my psql tables a need an email to be sent to pre-defined users.
The users will be 'interested parties' to the record inserted - therefore
these will be specified in a separate table. Is there a method for
completing this process?

Thanks for your time and help.

Kindest Regards


Nick Tew
Intranet Data Analyst
Phone: 01933 408225
Mobile: 07793 227001
Fax: 01933 408324
Email: nick.tew@budgens.co.uk



**********************************************************************
This e-mail is private and confidential and is for the
addressee only. You are prohibited from using, printing,
distributing or disseminating it or any information contained
in it, save to the intended recipient.
**********************************************************************