Display nuosql Output Vertically
By default, nuosql
reports query output in horizontal columns, such as:
SELECT * FROM t;
X Y Z
--- ------- -----
1 hello 12.34
10 goodbye 56.78
100 nuodb 10.10
When there are many columns referenced in a query, or one or more columns in the result set have very long string data or string data with new lines, then this default output can be hard to read.
In such cases, to display the output from queries vertically, specify the --vertical-output
nuosql
option or use the SET OUTPUT VERTICAL
command.
For example:
SET OUTPUT VERTICAL;
SELECT * FROM t;
==================================== Row #1 ====================================
X: 1
Y: hello
Z: 12.34
==================================== Row #2 ====================================
X: 10
Y: goodbye
Z: 56.78
==================================== Row #3 ====================================
X: 100
Y: nuodb
Z: 10.10