From: | Doug McNaught <doug(at)mcnaught(dot)org> |
---|---|
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 01:00:24 |
Message-ID: | 87u0uirefr.fsf@asmodeus.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ron St-Pierre <rstpierre(at)syscor(dot)com> writes:
> 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).
How about putting ">/dev/null 2>&1" after the command line in your crontab?
Or redirect it to a file if you think you might need it...
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
From | Date | Subject | |
---|---|---|---|
Next Message | Joel | 2004-09-01 02:04:28 | Re: Representating a family tree |
Previous Message | Ron St-Pierre | 2004-09-01 00:26:37 | Suppress output from psql? |