Option to suppress status messages when running -f mode
All, Is there a way to suppress the output of status messages like "3000 affected rows" when using mclient and "-f csv"? I have an sql script where I keep reducing a table and inserting the rows into another table. The final sql command extracts the final result. Would be nice if the status messages could be suppressed completely or sent to stderr (a --quiet option). I could also just run two scripts, or pipe the output through grep to remove the offending lines. Thanks, Dave
On 17/02/17 13:37, Anderson, David B wrote:
All, Is there a way to suppress the output of status messages like "3000 affected rows" when using mclient and "-f csv"? I have an sql script where I keep reducing a table and inserting the rows into another table. The final sql command extracts the final result. Would be nice if the status messages could be suppressed completely or sent to stderr (a --quiet option). I could also just run two scripts, or pipe the output through grep to remove the offending lines. Thanks, Dave
I'm not getting any "affected rows" messages when I use -fcsv. -- Sjoerd Mullender
small correction / clarification: -fcsv seems to suppress the "x tuples" information/message with select queries, but does not seem to suppress the "y affected rows" information/message with update/insert/etc. queries; at least not with Dec2016-SP1. Best, Stefan ----- On Feb 17, 2017, at 2:20 PM, Sjoerd Mullender sjoerd@acm.org wrote:
On 17/02/17 13:37, Anderson, David B wrote:
All, Is there a way to suppress the output of status messages like "3000 affected rows" when using mclient and "-f csv"? I have an sql script where I keep reducing a table and inserting the rows into another table. The final sql command extracts the final result. Would be nice if the status messages could be suppressed completely or sent to stderr (a --quiet option). I could also just run two scripts, or pipe the output through grep to remove the offending lines. Thanks, Dave
I'm not getting any "affected rows" messages when I use -fcsv.
-- Sjoerd Mullender
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (3)
-
Anderson, David B -
Sjoerd Mullender -
Stefan Manegold