postgresql - How to suppress INFO messages when running psql scripts -


When I run my trial and I thought got rid of me I see the notification message Here's my order by setting PGOPTION client_min_messages:

  PGOPTIONS = '- client-min-message = warning' \ psql -h localhost \ -P-5432 \ -d my_db \ -U my_user \ --no-align \ - Field-Separator '|' \ --pset footer \ --quiet \ -v AUTOCOMMIT = off \ -X \ -v VERBOSITY = abbreviations \ -v ON_ERROR_STOP = 1 \ --pset pager = off \ -f test / test.sql \ -o "$ How can I turn off information messages?   

This works for me (Debian GNU PostgreSQL 9.1.4 on Linux):

  en pGOPTIONS = '- c client_min_messages = warning' psql ...   

I have a manual about it I do.

Note, however, that there is no message level for INFO . This is only applicable to and log_mini_rearantement .

Comments