ArangoDB v3.2 reached End of Life (EOL) and is no longer supported.

This documentation is outdated. Please see the most recent version here: Try latest

ArangoDB Shell Output

The ArangoDB shell will print the output of the last evaluated expression by default:

arangosh> 42 * 23
Show execution results
966
Hide execution results

In order to prevent printing the result of the last evaluated expression, the expression result can be captured in a variable, e.g.

arangosh> var calculationResult = 42 * 23
Show execution results

        
Hide execution results

There is also the print function to explicitly print out values in the ArangoDB shell:

arangosh> print({ a: "123", b: [1,2,3], c: "test" });
Show execution results
{ 
  "a" : "123", 
  "b" : [ 
    1, 
    2, 
    3 
  ], 
  "c" : "test" 
}
Hide execution results

By default, the ArangoDB shell uses a pretty printer when JSON documents are printed. This ensures documents are printed in a human-readable way:

arangosh> db._create("five")
arangosh> for (i = 0; i < 5; i++) db.five.save({value:i})
arangosh> db.five.toArray()
Show execution results
[ArangoCollection 39351, "five" (type document, status loaded)]
[ 
  { 
    "_key" : "39354", 
    "_id" : "five/39354", 
    "_rev" : "_YTVPota---", 
    "value" : 0 
  }, 
  { 
    "_key" : "39361", 
    "_id" : "five/39361", 
    "_rev" : "_YTVPota--A", 
    "value" : 2 
  }, 
  { 
    "_key" : "39367", 
    "_id" : "five/39367", 
    "_rev" : "_YTVPote--_", 
    "value" : 4 
  }, 
  { 
    "_key" : "39358", 
    "_id" : "five/39358", 
    "_rev" : "_YTVPota--_", 
    "value" : 1 
  }, 
  { 
    "_key" : "39364", 
    "_id" : "five/39364", 
    "_rev" : "_YTVPote---", 
    "value" : 3 
  } 
]
Hide execution results

While the pretty-printer produces nice looking results, it will need a lot of screen space for each document. Sometimes a more dense output might be better. In this case, the pretty printer can be turned off using the command stop_pretty_print().

To turn on pretty printing again, use the start_pretty_print() command.