About Stacked Results in PostgreSQL

In PostgreSQL shell, add \gx instead of ; at the end of a SELECT query to see results stacked instead in a tabular view. That's very useful with wide tables which don't fit into the console window.

SELECT * FROM "accounts_user" WHERE "is_staff"=true \gx

Tips and Tricks Programming Databases PostgreSQL