David you can to use:
SELECT ASEWKT(the_geom) ....
or use:
SELECT x(the_geom), x(the_geom) ...
x is long and y is lat

2008/8/11 David Calle <[EMAIL PROTECTED]>

> Hi List,
>
> I need to convert geometry information to the GPS format:
>
> 01010000202D610000E81559FA0BD62541DA82728C04776241
> to
> lat:   -2.9033  long:    -79.138
>
> Using PostGis functions like GeometryfromText.... thanks
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 

Cordial Saludo,

Jaime Mejía
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to