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 > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
