Checkout http://www.hentzenwerke.com/wp/cron_explained.pdf
Look for the MAILTO="" command which you can use to suppress the mailing of cron job output.
And try redirecting std output to /dev/null, and/or send the output from psql to a file.
John Sidney-Woollett
Ron St-Pierre wrote:
Is there a way 'within' psql to suppress output?
One of our cron scripts calls a sql file which contains various database
commands (ALTER TABLEs, UPDATEs, etc) and various user-defined functions.
So within this sql file there are various SELECT * FROM myFunction(); which
sends output to the user from cron. I can't see anyway to suppress this from
the psql docs and I don't believe that I can suppress it from cron either (I'll do
some more checking there).
Thanks Ron
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
