<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>Hi</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I am using the following</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV> <FONT face=Calibri>pgsql2shp -f Test.shp -u postgres -P London2342 -k
PDW p_id.image -g the_geom</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>to export a shape file from postgis.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Even tho I specify a single geometry column to be
exported I get warnings that column names have been truncated.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Command prompt also informs me that "No prj file will be
generated"</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Also a warning 'cannot determine spatial reference". I
thought the default was -1?</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I also get messages-</FONT></DIV>
<DIV><FONT face=Calibri> "Done (postgis major version: 1)</FONT></DIV>
<DIV><FONT face=Calibri>Output shape: Polyline</FONT></DIV>
<DIV><FONT face=Calibri>Dumping: xx [8 rows]"</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>What am I doing wrong???</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Bob</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri></FONT> </DIV></BODY></HTML>