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

> > 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.