Re: How to suppress NOTICE messages

"O.B." <funkjunk@bellsouth.net> writes:
> How does one suppress NOTICE messages from appearing in stderr?  I
> have the following command and it appears that setting
> client_min_messages to WARNING does not work.

> psql -U postgres -d mytestdb -f mytest.sql -v
> client_min_messages=WARNING -W

You seem to be confusing psql variables (\set) with server configuration
parameters (SET) ... there is no connection there at all.

What you need is a SQL command "SET client_min_messages=WARNING;".
If you don't want to put it in your scripts, consider a ~/.psqlrc
file, or use ALTER USER or ALTER DATABASE to make it default at
those granularities, or change the installation's default in
postgresql.conf.  See
http://www.postgresql.org/docs/8.2/static/config-setting.html
for more ways to control configuration parameters.

            regards, tom lane