[postgis-users] help with pgsql2shp error

[strk]

On Sat, Nov 06, 2010 at 01:44:12PM -0400, Sam Snellings wrote:
> Thanks for the ::geometry tip.
> 
> (database geog_test, my data) *select count(asEWKB(location::geometry)) from
> global_points;*
> 
> count: 1
> 
> (database geog_three, tutorial data) *select count(asEWKB(geog::geometry))
> from airports;*
> 
> count: 3

The suggestion was due to the fact that pgsql2shp should be 
using that call. In particular:

 asEWKB(setSRID("%s"::geometry, -1), 'XDR')

Want to try that as well ?
(substitute %s with the name of your geometry column)

--strk;

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