How to wrap long lines when SELECTing SQL text columns?
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