[postgis-users] viewing a large postgis table with several columns

[strk at refractions.net]

On Tue, Jan 24, 2006 at 02:52:56AM -0800, First Last wrote:
> 
> i have a big postgis table with several columns and whenever i try to display the content of that table using a select statement in postgresql(psql) i get several blank pages, followed by several pages with only dashes as content, then the geometry. it will take several pressings of the space bar before i get to the geometry part even if i limit the number of columns and rows to display in the select statement. also there are but a few rows with blank values and no record with a value of "-" so i don't know if i'm getting garbage result.

That's not "garbage", it's "presentation" :)

 column name
-------------
 value
(# rows)

See pgsql manual or type \h from inside the monitor to
know how to change that. IIRC \t is your friend here.

--strk;