Re: Suppress output from psql?

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: Raw Message | Whole Thread | 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
>

In response to

Browse pgsql-general by date

  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