Re: How to hide NOTICE messages in psql.exe ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Szymic1 <dyrex(at)poczta(dot)onet(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to hide NOTICE messages in psql.exe ?
Date: 2006-07-05 14:30:16
Message-ID: 20060705143015.GA19681@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 05, 2006 at 07:12:02AM -0700, Szymic1 wrote:
> I use psql.exe program under windows and I would like that program will
> hide all NOTICE messages. Is there any psql.exe parameter ? Because of
> big number of NOTICE messages is very hard to find errors.

Does "SET client_min_messages TO warning" do what you want? You
might also be interested in psql's -q option (or "\set QUIET").

http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
http://www.postgresql.org/docs/8.1/interactive/app-psql.html

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Bizzarri 2006-07-05 14:43:22 Dumping in LATIN1 and restoring in UTF-8
Previous Message Szymic1 2006-07-05 14:12:02 How to hide NOTICE messages in psql.exe ?