Why not create a cron script which connects to the database and queries
your tables (using psql). Have it generate an output (shell) script which
your original script then calls.
Unfortunately I know how to do this with Oracle, but not postgres *yet*,
but I suspect that in principle this idea will work.
Maybe someone else has an example, or a better suggestion.
John Sidney-Woollett
Philippe Lang said:
> 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
>