Re: Shell access & send email from PLPGSQL?

Philippe Lang wrote:

>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!
>
>
You can also use plPHP with it's built in mail() function.

>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
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org