How to hide NOTICE messages in psql.exe ?

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

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

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.

On Wed, Jul 05, 2006 at 07:48:21AM -0700, Szymic1 wrote:

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

[...]

I would like to hide lines with NOTICE

I mentioned -q as something you might want to use in addition
to client_min_messages, not instead of it. My previous message
showed how to suppress NOTICE and provided a link to the relevant
documentation.

--
Michael Fuhr