Re: psql too noisy - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: psql too noisy
Date
Msg-id 20061219151934.GM27098@alvh.no-ip.org
Whole thread Raw
In response to psql too noisy  (Marc Evans <Marc@SoftwareHackery.Com>)
List pgsql-general
Marc Evans wrote:
> Hello -
>
> Can anyone suggest a way to suppress all STDOUT/STDERR output by the psql
> utility, except for >= ERROR level messages? In particular, I am trying
> to suppress NOTICE level messages. The purpose behind this is so that when
> a lengthy script is fed to psql to build a virgin DB, the many NOTICE
> lines output about things like "implicit sequence" and "implicit index"
> are suppressed.

Set client_min_messages to WARNING.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Savepoints in PL/pgSQL
Next
From: Richard Broersma Jr
Date:
Subject: Re: feature request for Postgresql Rule system.