As far as I know, all versions of pgsql2shp work just fine on Win7, and they should do exactly what they are documented to do for the situation you describe. What exactly are your problems? If the command had an error and didn't produce any files, what did you type?
-Mike On 10 October 2010 14:03, Bob Pawley <rjpaw...@shaw.ca> wrote: > I'm still having problems. > > My pgsql2shp version is - > RCSID: $Id: pgsql2shp.c 4914 2009-11-27 18:12:43Z pramsey $ RELEASE: 1.4 > Is this the right version to be using on Win 7?? > > Bob > > -------------------------------------------------- > From: "Stephen Woodbridge" <wood...@swoodbridge.com> > Sent: Sunday, October 10, 2010 11:14 AM > To: <postgis-users@postgis.refractions.net> > Subject: Re: [postgis-users] pgsql2shp > >> On 10/10/2010 1:52 PM, Bob Pawley wrote: >>> >>> Hi >>> I am using the following >>> pgsql2shp -f Test.shp -u postgres -P London2342 -k PDW p_id.image -g >>> the_geom >>> to export a shape file from postgis. >>> Even tho I specify a single geometry column to be exported I get >>> warnings that column names have been truncated. >> >> DBF files can only have a maximum of 11 character column names. You >> probably have some that are longer. You can work around this problem by >> using a query at the end of the commandline like: >> >> 'select col1, col2, col3whichisverylong as col3, ... the_geom from >> p_id.image' >> >>> Command prompt also informs me that "No prj file will be generated" >>> Also a warning 'cannot determine spatial reference". I thought the >>> default was -1? >> >> -1 is the default and it means that you have not defined a projection so >> it can not create a .prj file. It is generally a good idea to always define >> a projection for your data. >> >> -Steve W >> >>> I also get messages- >>> "Done (postgis major version: 1) >>> Output shape: Polyline >>> Dumping: xx [8 rows]" >>> What am I doing wrong??? >>> Bob >>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
