[postgis-users] Shapes to PG

Nicolas Ribot nicky666 at gmail.com
Mon Jan 26 06:17:42 PST 2009

> OK, my selection was
> select * from onb
> This comes up with a couple of lines, containing the_geometry and much more,
> not containing a value in this column.

To "see" the geometries, or at least to display their coordinates in a
friendly manner, you should convert them to a textual representation:

select st_astext(the_geom) from onb;


More information about the postgis-users mailing list