Michael Smedberg wrote:
> You can use the astext function to get the WKT ("well known text".)
> E.g. you could do something like:
>
> SELECT astext(the_geom) FROM library.dgm_process
>
> which would return a textual representation of the geometries.
> ST_GeomFromText is the opposite of astext- it'll convert the text to a
> geometry object.
I suggest the use of the binary WKB format to avoid precision quirks
that might occur with WKT.
SELECT ST_AsBinary(the_geom) FROM ...;
--
Maxime
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
