Skip site navigation (1) Skip section navigation (2)

Send email when new record inserted

From: Nick Tew <Nick(dot)Tew(at)Budgens(dot)co(dot)uk>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Send email when new record inserted
Date: 2004-02-12 10:45:29
Message-ID: FF981F1E1A41D3118CFE00508B12AA0906C62E7D@compaq1.budgens.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
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(dot)tew(at)budgens(dot)co(dot)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.
**********************************************************************


Responses

pgsql-novice by date

Next:From: Bruno LEVEQUEDate: 2004-02-12 10:54:49
Subject: Re: Performing COPY Command
Previous:From: Rajan BhideDate: 2004-02-12 09:44:21
Subject: Re: Performing COPY Command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group