[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;

Nicolas



More information about the postgis-users mailing list