[postgis-users] pgsql2shp having trouble finding geometry column

[strk at refractions.net]

You don't need the AsText call, as the dumper will detect
a geometry column by it's type. Calling AsText() makes
the type of the the_geom column 'text' rather then 'geometry'.

--strk;

On Wed, Nov 16, 2005 at 01:25:49AM -0800, Eric Hanson wrote:
> Hey,
> 
> I'm running into some troubles using pgsql2shp.  It seems to not be able 
> to find the geometry column:
> 
> elhanson:~/public_html/oscdl/bin:544 > pgsql2shp -h localhost \
> -p 5432 \
> -u mapserve \
> -f r2001_maj_art.shp \
> newrlis \
> "SELECT AsText(the_geom) AS the_geom FROM r2001_maj_art WHERE the_geom 
> && SetSRID ('BOX3D(7505411 556856, 7832855 778550)'::box3d,2913)"
> Preparing table for user query... Done.
> Initializing... No geometry column found.
> The DBF file will be created but not the shx or shp files.
> Done (postgis major version: 1).
> Output shape: Null Shape
> Dumping: XXXXXXXXXXXXXXXXXXXXXXXXXX [2484 rows].
> elhanson:~/public_html/oscdl/bin:545 >
> 
> There's definately a geometry column called the_geom.  Any ideas?
> 
> Thanks,
> Eric
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email