Re: Shell access & send email from PLPGSQL?

Hello,

This is exactly what I needed. It works just fine for me, except when a function is being created through the pgAdmin III (version 1.02 under Windows). In this case, I think functions are being stored in the database with a CR/LF at the end, what the plpgsh engine does not like at all!

Except this, that's fine. Thanks.

-------------------------
Philippe Lang
Attik System
http://www.attiksystem.ch

-----Message d'origine-----
De : Pavel Stehule [mailto:stehule(at)kix(dot)fsv(dot)cvut(dot)cz]
Envoyé : mardi, 9. décembre 2003 11:33
À : Philippe Lang
Cc : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] Shell access & send email from PLPGSQL?

Hello

If you require only send mail, try pgsendmail.
http://sourceforge.net/project/showfiles.php?group_id=35804.
You can use plsh too.
http://developer.postgresql.org/~petere/pgplsh/

regards
Pavel Stehule

On Tue, 9 Dec 2003, Philippe Lang wrote:

> Hello,
>
> How can open a unix shell from a PLPGSQL function / trigger?
>
> I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
>
> Thanks
>
> -------------------------
> Philippe Lang
> Attik System
> http://www.attiksystem.ch
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>