[postgis-users] pgsql2shp

[Stephen Woodbridge]

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