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" <[email protected]>
Sent: Sunday, October 10, 2010 11:14 AM
To: <[email protected]>
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
