How to wrap long lines when SELECTing SQL text columns? I'm selecting from a table with long text columns. I'd like to wrap long lines to a maximum line length.

From:

SELECT * FROM test;
test_id |                                  text
--------+-----------------------------------------------------------------------
      1 | Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris lorem


To:

test_id |              text
--------+-----------------------------
      1 | Lorem ipsum dolor sit amet,+
        | consectetur adipiscing elit+
        | . Mauris lorem
If you're using the psql command line tool, issue this command first:

\pset format wrapped


It should then wrap long lines to your terminal window like so:

test_id |              text
--------+-----------------------------
      1 | Lorem ipsum dolor sit amet,.
        |.consectetur adipiscing elit.
        |.. Mauris lorem


You can also set the number of columns to wrap to with

\pset columns 100


and you can change the dots to ellipses with

\pset linestyle unicode


More info: http://www.postgresql.org/docs/current/static/app-psql.html