On 2009-08-11, Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be> wrote:
>
> Hi All,
>
> I was looking in what way it's possible to alert via mail when some conditi=
> ons are true in a database.
>
> Thanks in advance!
Assuming you mean email, and not ink on paper (hmm, OTOH you could load
postcards into a printer....)
you could do this using NOTIFY and a listener written in some other
langauge, notify is really neat.
or possibly invoke mail(1) with a plpythonu or C function,
or as superuser you can write a file (using copy ...) and arrange for something else to
look, find it, and mail it.
arbitrary file contents are possible with copy:
COPY (SELECT NULL) TO myfile_name WITH NULL AS myfile_contents;