[postgis-users] pgsql2shp buffer

[strk at refractions.net]

pgsql2shp calls DBFWriteAttributeDirectly from shapelib at each record,
with no own buffering.

I suggest you try with pgsql2shp from postgis-1.0.0, as it should
work with all postgis versions, and it is actively maintained.

--strk;

On Fri, Mar 25, 2005 at 02:25:47PM -0500, Purvis, Charlton wrote:
> Hi, folks:
> 
> 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.
> 
> 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.
> 
> postgresql-7.4.1/contrib/postgis-0.8.1
> 
> Thanks,
> 
> Charlton
> 
>  
>  
>  
> Charlton Purvis
> (803) 777-8858 : voice
> (803) 777-3935 : fax
> cpurvis at sc.edu
>  
> Baruch Institute
> University of South Carolina
> Columbia, SC 29208
> 

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users