<!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>pgsql2shp buffer</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi, folks:</FONT>
</P>
<P><FONT SIZE=2>I'm curious if pgsql2shp writes to a buffer of some sort before it actually starts writing to a .dbf. I'm trying to dump about 0.5 million rows which shouldn't be too bad and shouldn't take too long. However, pgsql2shp seems to sit there w/ only a 1 byte (or KB?) .dbf. Should I turn on debugging? I'd hate to recompile PostGIS.</FONT></P>
<P><FONT SIZE=2>If I type a select * from table_name (the one I'm trying to create the shp from), it returns w/i a minute or two. But I'm sure psql is doing buffering of its own.</FONT></P>
<P><FONT SIZE=2>postgresql-7.4.1/contrib/postgis-0.8.1</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
</P>
<P><FONT SIZE=2>Charlton</FONT>
</P>
<P><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Charlton Purvis</FONT>
<BR><FONT SIZE=2>(803) 777-8858 : voice</FONT>
<BR><FONT SIZE=2>(803) 777-3935 : fax</FONT>
<BR><FONT SIZE=2>cpurvis@sc.edu</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Baruch Institute</FONT>
<BR><FONT SIZE=2>University of South Carolina</FONT>
<BR><FONT SIZE=2>Columbia, SC 29208</FONT>
</P>
</BODY>
</HTML>