Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux