The reason I asked is that I had tyo upgrade pgdump in order to get it to
work.
I'm using this (and variations of it)
pgsql2shp -f c:\user\bob\ShapeTest.shp -h localhost -u postgres -P
London2342 PDW
"Select the_geom from p_id.image where p_id_id = '1534'"
or
pgsql2shp -f myfile.shp -h localhost -u postgres -P London2342 PDW
p_id.image -g the_geom
The message just tells me that "No prj file will be generated".
I am using 8.4 if that helps.
Bob
--------------------------------------------------
From: "Mike Toews" <[email protected]>
Sent: Monday, October 11, 2010 1:30 PM
To: "PostGIS Users Discussion" <[email protected]>
Subject: Re: [postgis-users] pgsql2shp
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 <[email protected]> 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" <[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
_______________________________________________
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
