| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Marc Evans <Marc(at)SoftwareHackery(dot)Com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql too noisy |
| Date: | 2006-12-19 15:19:34 |
| Message-ID: | 20061219151934.GM27098@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-12-19 15:22:36 | Re: feature request for Postgresql Rule system. |
| Previous Message | Bernd Helmle | 2006-12-19 15:16:12 | Re: Savepoints in PL/pgSQL |