All versions: 3.10 | 3.9 | 3.8 | 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | Development versions: 3.11 | Unsupported versions: 3.2 | 3.1 | 3.0 | 2.6

// Fetch books and format them as text
String text = create.selectFrom(BOOK).fetch().format();

The above query will result in a text document looking like the following one

+---+---------+-----------+
| ID|AUTHOR_ID|TITLE      |
+---+---------+-----------+
|  1|        1|1984       |
|  2|        1|Animal Farm|
+---+---------+-----------+

A simple text representation can also be obtained by calling toString() on a Result object. See also the manual's section about DEBUG logging

The jOOQ Logo