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

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.