json

Options

-b,--binary <base64 | hex>   sets the binary format.
-p,--pretty <on | off>       turns pretty print on / off.

Note

• Binary types are converted to either base64 (default) or hexadecimal format.

• Array and Struct types are converted to JSON array type.

  • For Teradata, PERIOD data types, which are transmitted as Struct types, are converted into formats that matches their BTEQ output formats.

Example

.format json -b hex
-- 4/6 - 0 ----------------------------------------------------------------
SELECT * FROM BinTable ORDER BY a;
-- success --
[
        {
                "a" : 1,
                "b" : "deadbeef"
        },
        {
                "a" : 2,
                "b" : "facedead"
        }
]
-- activity count = 2