Re: How to hide NOTICE messages in psql.exe ? - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: How to hide NOTICE messages in psql.exe ?
Date
Msg-id 20060706180215.1075.qmail@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to Re: How to hide NOTICE messages in psql.exe ?  ("Szymic1" <dyrex@poczta.onet.pl>)
List pgsql-general
> > might also be interested in psql's -q option (or "\set QUIET").
>
> I use -q but I've got e.g
>
> Z:\>psql.exe -q -d ff -h localhost -p 5432 -U postgres
> 0<D:\ff\centralny\src\db\processing_utils.sql
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
> NOTICE:  type reference freeconet.logic_list_item.conv%TYPE converted
> to charact
> er varying
> NOTICE:  type reference ff.logic_list_item.conv%TYPE converted to
> charact
> er varying
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
> NOTICE:  type reference ff.account.user_name%TYPE converted to
> character
> varying
> NOTICE:  type reference ff.alias.mask%TYPE converted to character
> varying
>
> I would like to hide lines with NOTICE


Would making the following changes to you postgresql.conf help?

redirect_stderr = true
client_min_messages = warning

You may need to restart PostgreSQL for these changes to take effect.

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: "Szymic1"
Date:
Subject: Re: How to hide NOTICE messages in psql.exe ?
Next
From: Stephen Frost
Date:
Subject: Re: Backing up the currently used wal segment