Thread: FW: Reduce pl/pgsql output

I actually tried that using the SET log_min_messages TO log-level
command.

The NOTICE and CONTEXT messages came out just as usual.  Did I do
something wrong or do I need to do something different?

Josh

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of A. Kretschmer
Sent: Thursday, August 03, 2006 8:46 AM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Reduce pl/pgsql output
Importance: High

am  03.08.2006, um  8:29:13 -0700 mailte Garcia, Joshua folgendes:
> How can I reduce the output sent to the screen, such as the "NOTICE"
and
> "CONTEXT" outputs?


reduce the log-level.

log_min_messages or client_min_messages, i'm not sure.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

"Garcia, Joshua" <Joshua.Garcia@xerox.com> writes:
> I actually tried that using the SET log_min_messages TO log-level
> command.
> The NOTICE and CONTEXT messages came out just as usual.  Did I do
> something wrong or do I need to do something different?

If you are unhappy with what appears on your terminal, you probably want
to fool with client_min_messages, instead.  Also, if using psql, try
experimenting with "\set VERBOSITY terse" to reduce the amount of
chatter per message.

            regards, tom lane