[postgis-users] from EWKB to WKB

[Mike Toews]

Use ST_AsText(geom)

http://www.postgis.org/docs/ST_AsText.html

-Mike

On 25 April 2013 21:58, Denis Rouzaud <denis.rouzaud at gmail.com> wrote:
> Hi all,
>
> I have a EKWB string, and I'd like to transform it to WKB.
>
> Can I do this by removing the characters from position 3 to 10, like:
>
>
> SELECT 'SRID=4;POINT(1 0)'::geometry
> 01 01000020 04000000 000000000000F03F0000000000000000
>
> 'POINT(1 0)'::geometry;
> 01 01000000          000000000000F03F0000000000000000
>
> Thanks a lot,
>
> Denis
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>