By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,542 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,542 IT Pros & Developers. It's quick & easy.

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

P: n/a
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....

Thanks
---------------------------------------------------------------------------
----------------
Patrick Fiche
email : pa***********@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------


Protected by Polesoft Lockspam
http://www.polesoft.com/refer.html

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Nov 23 '05 #2

P: n/a
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.sea...rror_verbosity

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #3

P: n/a
David Rysdam <dr*****@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #4

P: n/a
Tom Lane wrote:
David Rysdam <dr*****@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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.