[postgis-users] help with pgsql2shp error

strk strk at keybit.net
Sat Nov 6 07:22:40 PDT 2010

On Fri, Nov 05, 2010 at 09:43:14PM -0400, Sam Snellings wrote:
> select count(asEWKB(the_geom)) from global_points;
> Returns the following error:
> ERROR: function asewkb(geography) does not exist

Try asewkb(the_geom::geometry)

> asEWKB(), ST_isValid() and ST_isValidReason() don't work with geography data types,
> correct?

You can cast geography to geometry using the ::geometry operator.


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

More information about the postgis-users mailing list