[postgis-users] pgsql2shp

[Mike Toews]

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 <rjpawley at 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" <woodbri at swoodbridge.com>
> Sent: Sunday, October 10, 2010 11:14 AM
> To: <postgis-users at 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 at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>