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 P > On Jan 21, 2019, at 2:39 PM, Martin Davis <mtncl...@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 <si...@spatialdbadvisor.com > <mailto:si...@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@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
