[postgis-users] Geography/geometry

Paul Ramsey pramsey at cleverelephant.ca
Mon Jan 21 14:41:44 PST 2019

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

select encode(st_asbinary(geom), ‘hex’) 

will do that


> On Jan 21, 2019, at 2:39 PM, Martin Davis <mtnclimb at gmail.com> wrote:
> Not much help, I'm afraid.   I need the geometry in WKBHex.  Not sure offhand how to get that out of PostGIS.
> Just post the WKT and let's see what that looks like.
> On Mon, Jan 21, 2019 at 1:52 PM Simon Greener <simon at spatialdbadvisor.com <mailto:simon at spatialdbadvisor.com>> wrote:
> Try here for an example:
> https://www.dropbox.com/s/n234bc6i5hj7y4o/Ireland.sql?dl=0 <https://www.dropbox.com/s/n234bc6i5hj7y4o/Ireland.sql?dl=0>_______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190121/af5eb62a/attachment.html>

More information about the postgis-users mailing list