Обсуждение: Send Email from Postgressql
Thanks for your time.
I need to notify a user that data has changed. To accomplish this I'd like to create a trigger that watches the specified table, that on change, sends the results returned by a function in the body of an email to a specific user.
Is this possible?
Live Search: Better results, fast Try it now!
I need to notify a user that data has changed. To accomplish this I'd like to create a trigger that watches the specified table, that on change, sends the results returned by a function in the body of an email to a specific user.
Is this possible?
Live Search: Better results, fast Try it now!
am Thu, dem 01.02.2007, um 8:54:34 -0600 mailte brian stapel folgendes: > Thanks for your time. > > I need to notify a user that data has changed. To accomplish this I'd like to > create a trigger that watches the specified table, that on change, sends the > results returned by a function in the body of an email to a specific user. > > Is this possible? Yes. You can write such with a untrusted pl such as plperlu or plsh. I have a function in plsh, within there i call mutt (a command-line mail programm on linux) to send mail. The To: and other headers are parameters. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
Thanks for your quick reply.
So, working from your example, I would build a trigger that calls a function that calls the email program?
I'm new to PostgreSQL and I'm a windows developer. I've been using PLPGSQL for all of my functions. The other languages you mentioned, are they easily learned?
> Date: Thu, 1 Feb 2007 16:03:57 +0100
> From: andreas.kretschmer@schollglas.com
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] Send Email from Postgressql
>
> am Thu, dem 01.02.2007, um 8:54:34 -0600 mailte brian stapel folgendes:
> > Thanks for your time.
> >
> > I need to notify a user that data has changed. To accomplish this I'd like to
> > create a trigger that watches the specified table, that on change, sends the
> > results returned by a function in the body of an email to a specific user.
> >
> > Is this possible?
>
> Yes.
>
> You can write such with a untrusted pl such as plperlu or plsh.
> I have a function in plsh, within there i call mutt (a command-line mail
> programm on linux) to send mail. The To: and other headers are
> parameters.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
Live Search: New search found Try it!
So, working from your example, I would build a trigger that calls a function that calls the email program?
I'm new to PostgreSQL and I'm a windows developer. I've been using PLPGSQL for all of my functions. The other languages you mentioned, are they easily learned?
> Date: Thu, 1 Feb 2007 16:03:57 +0100
> From: andreas.kretschmer@schollglas.com
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] Send Email from Postgressql
>
> am Thu, dem 01.02.2007, um 8:54:34 -0600 mailte brian stapel folgendes:
> > Thanks for your time.
> >
> > I need to notify a user that data has changed. To accomplish this I'd like to
> > create a trigger that watches the specified table, that on change, sends the
> > results returned by a function in the body of an email to a specific user.
> >
> > Is this possible?
>
> Yes.
>
> You can write such with a untrusted pl such as plperlu or plsh.
> I have a function in plsh, within there i call mutt (a command-line mail
> programm on linux) to send mail. The To: and other headers are
> parameters.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
Live Search: New search found Try it!
am Thu, dem 01.02.2007, um 9:10:57 -0600 mailte brian stapel folgendes: > Thanks for your quick reply. > > So, working from your example, I would build a trigger that calls a function > that calls the email program? > I'm new to PostgreSQL and I'm a windows developer. I've been using PLPGSQL for > all of my functions. The other languages you mentioned, are they easily > learned? Depends. For instance, do you have knowledge about the programming language PERL? If so, then you don't have problems with plperlu, i think. And for PERL there are tons of example code to send emails. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
On Thu, Feb 01, 2007 at 08:54:34 -0600, brian stapel <brians_224@hotmail.com> wrote: > > I need to notify a user that data has changed. To accomplish this I'd like to create a trigger that watches the specifiedtable, that on change, sends the results returned by a function in the body of an email to a specific user. Yes this is possible to do with untrusted languages. For example you might install perlu and write your function in that.
Hello, On Thu, 2007-02-01 at 08:54 -0600, brian stapel wrote: > I need to notify a user that data has changed. To accomplish this I'd > like to create a trigger that watches the specified table, that on > change, sends the results returned by a function in the body of an > email to a specific user. http://archives.postgresql.org/pgsql-general/2006-10/msg01351.php might work for you, I think. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/