Tagebuch eines Technikers

Sunday, February 22, 2009

Display result of select in vertical format

Sometimes the default way of displaying query results in tabular format can be quite annoying. Escpecially, when you have to view them i a small CL window. Fortunately, there is a workaroung:

SELECT * FROM USER\G

By replacing the default ; with \G, the result gets displayed in vertical format. Of course, this needs more vertical space in the CL window. On the other hand, you do not have to deal with annoying line wrapping and stuff.
Be sure to use a capital G though, otherwise this will not work and result in the default tabular view instead.

No comments: