[postgis-users] Difference between "Geometry" and "BLOB" in Postgis

[Sandro Santilli]

On Fri, Oct 31, 2014 at 12:26:44PM -0400, Robert Burgholzer wrote:
> Thanks for the response - I was thinking that may be the case.  I suppose I
> should ask if PostGIS has anything that would make it behave badly when
> called on geometries stored as plain old blob's?

PostgreSQL would only call PostGIS functions taking Geometry if you pass
them what PostgreSQL belives being Geometry objects. At which level
are you acting here ? At SQL level a "bytea" could be converted to
a "geometry" object implicitly using the bytea::geometry cast, which
assumes the bytea is in EWKB format.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html