Thread: psql : how to make it more silent....

• PL/pgSQL function "adm_user" line 321......
• CONTEXT: SQL query "SELECT....."

-------------------------------------------------------------------------------------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
-------------------------------------------------------------------------------------------

Protected by Polesoft Lockspam

http://www.polesoft.com/refer.html

Patrick Fiche wrote:
> Hi,
>
> When I execute a function, I would like psql to show me only RAISE
> NOTICE messages but not all function calls....
> Indeed, I currently get some messages that I don't care about :
>
>
>     * PL/pgSQL function "adm_user" line 321......
>     * CONTEXT: SQL query "SELECT....."
>
> Is there a way to get rid of these messages....
>

modify your log_error_verbosity  to "terse"



Regards
Gaetano Mendola

Gaetano Mendola wrote:

> Patrick Fiche wrote:
>
>> Hi,
>>
>> When I execute a function, I would like psql to show me only RAISE
>> NOTICE messages but not all function calls....
>> Indeed, I currently get some messages that I don't care about :
>>
>>
>>     * PL/pgSQL function "adm_user" line 321......
>>     * CONTEXT: SQL query "SELECT....."
>>
>> Is there a way to get rid of these messages....
>>
>
>
> modify your log_error_verbosity  to "terse"
>
I can't find anything else on that


http://search.postgresql.org/www.search?ul=http%3A%2F%2Fwww.postgresql.org%2Fdocs%2F7.4%2Fstatic%2F%25&q=log_error_verbosity

and I would like to have psql (optionally?) not even send me NOTICE
messages.

David Rysdam <drysdam@ll.mit.edu> writes:
> ... I would like to have psql (optionally?) not even send me NOTICE
> messages.

Have you looked at client_min_messages?

            regards, tom lane

Tom Lane wrote:

>David Rysdam <drysdam@ll.mit.edu> writes:
>
>
>>... I would like to have psql (optionally?) not even send me NOTICE
>>messages.
>>
>>
>
>Have you looked at client_min_messages?
>
>            regards, tom lane
>
>
>
>
I had not, because I'd never heard of it.  :)  Looks like exactly what I
want and what I was suspecting existed, thanks.