Re: turning off notices

On Sat, 19 Jan 2008, Sue Fitt wrote:

> Hi All,
>
> I'm having trouble with turning off notices. Within psql I use \set
> VERBOSITY terse, which is fine. However, using psql -c I am having
> trouble. It seems I should be able to use psql -qc 'mycommand' but I am
> still getting notices output, e.g.
>
> psql -d combilex -qc 'SELECT * FROM show(1135311);'
> NOTICE:  phonotactic error, please check transcription
> CONTEXT:  SQL statement "SELECT etc....
>
> Is there a way to turn these notices off other than reconfiguring the
> conf file and restarting the database? I am using 8.1.3.

If you want no notices, you could try "set client_min_messages TO
WARNING".