[postgis-users] pgsql2shp

[Bob Pawley]

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
>