Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql too noisy

psql too noisy

From
Marc Evans
Date:
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.

I have tried -q and -v VERBOSITY='terse' with no observed effect.

Thanks in advance - Marc

Re: psql too noisy

From
Alvaro Herrera
Date:
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.