<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>SQL Command Length / SHP2PGSQL / PostgreSQL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi List,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I am trying to put a shapefile into postgis/postgres. Seems that when shp2pgsql hits 16385 characters it stops writing the line. At first I thought it might be a limitation of my text editor, but that does not appear to be the case.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">So, is this because that is the command length allowed by postgres or something else?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">David Lowther</FONT>
<BR><FONT SIZE=2 FACE="Arial">Software Engineer</FONT>
<BR><FONT SIZE=2 FACE="Arial">GEO Information Systems</FONT>
<BR><FONT SIZE=2 FACE="Arial">University of Oklahoma</FONT>
<BR><FONT SIZE=2 FACE="Arial">dlowther@ou.edu</FONT>
<BR><FONT SIZE=2 FACE="Arial">(405) 325-3131</FONT>
<BR><A HREF="http://www.geo.ou.edu"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.geo.ou.edu</FONT></U></A>
</P>
<BR>
<BR>
</BODY>
</HTML>