A warped look at spatial...

Simple Psql Formating Tips

So you are neck deep in psql and are doing some queries… but the output looks like crap and the pager keeps getting in your way.

First… turn off the pager

\pset pager

Next, turn on expanded display


Now… things look a bit better. You dont loose your initial page by going into the pager, and your output is readable. This is especially true for very wide columns as is always happens with GIS data in postgis.