From: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
---|---|
To: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Suppress output from psql? |
Date: | 2004-09-01 07:43:27 |
Message-ID: | 41357D9F.8080009@wardbrook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-09-01 08:30:42 | Re: Rule/sequence weirdness |
Previous Message | Pierre-Frédéric Caillaud | 2004-09-01 07:09:52 | Re: Python Postgresql support? |