Print readable SQL output in unix terminal

Question

How can I output SQL in Terminal so that is readable even for very long rows?

I have SQL output that is very messy since each row is very long. This makes the table jumbled in my terminal.

I remember a way to output SQL so that it is readable by row. I believe it was done by adding a "\G" at the end of a query but I can't find any documentation on Google.

Tsar Ioann · Accepted Answer · 2013-06-04 21:28:56Z

2

On linux any output with long lines can be viewed this way:

program_that_produces_long_lines | less -S

You will have ability to use arrows to see what is outside the screen.

answered Jun 4, 2013 at 21:28

Tsar Ioann

4441 gold badge4 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Print readable SQL output in unix terminal

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related