<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Just ’select geom’ will return the extended hexwkb (which we should have JTS support as a matter of convenience). If you need pure standard hex wkb, then<div class=""><br class=""></div><div class="">select encode(st_asbinary(geom), ‘hex’) </div><div class=""><br class=""></div><div class="">will do that</div><div class=""><br class=""></div><div class="">P<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 21, 2019, at 2:39 PM, Martin Davis <<a href="mailto:mtnclimb@gmail.com" class="">mtnclimb@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Not much help, I'm afraid. I need the geometry in WKBHex. Not sure offhand how to get that out of PostGIS.<div class=""><br class=""></div><div class="">Just post the WKT and let's see what that looks like.</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 21, 2019 at 1:52 PM Simon Greener <<a href="mailto:simon@spatialdbadvisor.com" class="">simon@spatialdbadvisor.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u class=""></u>
<div class=""><div class="">Try here for an example:</div><div class=""><br class=""></div><div class=""><a href="https://www.dropbox.com/s/n234bc6i5hj7y4o/Ireland.sql?dl=0" target="_blank" class="">https://www.dropbox.com/s/n234bc6i5hj7y4o/Ireland.sql?dl=0</a></div></div></blockquote></div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</div></blockquote></div><br class=""></div></body></html>