| From: | Scott Gerhardt <scott(at)g-it(dot)ca> | 
|---|---|
| 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 04:30:23 | 
| Message-ID: | A43CA548-FBCF-11D8-9676-000393801C60@g-it.ca | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
You could redirect the output from your cron initiated script with:
 > /dev/null 2>&1
> 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 | Vidyasagara Guntaka | 2004-09-01 05:27:02 | Re: Not able to build libpq for Windows | 
| Previous Message | Cott Lang | 2004-09-01 03:41:45 | Re: Large Databases |