Is there any way to see the mongo results in a better format?

Question

Is there any way to see the mongo results in a better format, like we are using \G in the sql ?

Do you mean [pretty printing](http://stackoverflow.com/a/9146646/125816)? — Sergio Tulentsev, Dec 11 '12 at 06:11

score 6 · Answer 1 · answered Dec 11 '12 at 06:21

6

There is no way to enable vertical printing like what you would see in \G in MySQL. In the context that view is less useful, since MongoDB is a document store and can have nested documents and the like.

You can print out the results of a query in pretty printing, by adding a .pretty() to the query:

db.test.find().pretty()

Which will return the results in a expanded document view, which may be helpful.

answered Dec 11 '12 at 06:21

Andre de Frere

2,703
16
13

Nice one, this is as close as it gets to the MySQL way. – sij_a Jul 27 '16 at 10:37

Sushant Gupta · Accepted Answer · 2012-12-11T09:11:43.223

2

In addition to @Andre solution, in case you want to get only one element. You can use findOne function. It pretty prints that document.

db.test.findOne()

Also you can use toArray over a cursor. Though its a memory hog, but for small number of results its fine and pretty prints,

db.test.find({...}).toArray()

edited Dec 11 '12 at 09:11

answered Dec 11 '12 at 08:33

Sushant Gupta

8,980
5
43
48

Is there any way to see the mongo results in a better format?

2 Answers2