Normal Postgres Output - off the right hand side of the page or wrapped and unreadable
db_development=# select * from users; id | email | encrypted_password | reset_password_token | reset_password_sent_at | remember_created_at | sign_in_count | current_sign_in_at | last_sign_in_at | current_sign_in_ip | last_sign_in_ip | created_at | updated_at | admin ----+----------------------+--------------------------------------------------------------+----------------------+------------------------+---------------------+---------------+----------------------------+----------------------------+--------------------+-----------------+----------------------------+----------------------------+------- 1 | [email protected] | $2a$10$hHZ4XhiTgXY62slgpsXd3u2Nd0pC3Ejl0IbsNZK1t2r5aPlxyl3QO | | | | 1 | 2013-08-01 16:23:40.594673 | 2013-08-01 16:23:40.594673 | 127.0.0.1 | 127.0.0.1 | 2013-08-01 16:21:59.889625 | 2013-08-01 16:23:40.595853 | t (1 row)
Now - use the \x for expanded Display - much easier to read
db_development=# \x Expanded display is on. db_development=# select * from users; -[ RECORD 1 ]----------+------------------------------------------------------------- id | 1 email | [email protected] encrypted_password | $2a$10$hHZ4XhiTgXY62slgpsXd3u2Nd0pC3Ejl0IbsNZK1t2r5aPlxyl3QO reset_password_token | reset_password_sent_at | remember_created_at | sign_in_count | 1 current_sign_in_at | 2013-08-01 16:23:40.594673 last_sign_in_at | 2013-08-01 16:23:40.594673 current_sign_in_ip | 127.0.0.1 last_sign_in_ip | 127.0.0.1 created_at | 2013-08-01 16:21:59.889625 updated_at | 2013-08-01 16:23:40.595853 admin | t db_development=#