Displaying NuoDB SQL Output Vertically

By default nuosql reports query output in horizontal columns, such as:

SQL> SELECT * FROM t;
 X     Y      Z
--- ------- -----
1   hello   12.34
10  goodbye 56.78
100 nuodb   10.10
SQL>

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. An option instead would be to display the output from queries vertically as in the following example:

SQL> 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
SQL>

This can be accomplished by specifying the command line option --vertical-output command line option or with the SET OUTPUT VERTICAL command. See SET for more information.