[postgis-users] dbf2pgsql type utility

[strk at refractions.net]

On Thu, May 26, 2005 at 04:31:00PM -0400, Kralidis,Tom [Burlington] wrote:
> 
> > > Hi,
> > > 
> > > I have some pure attribute data which I will join to 
> > spatial tables in 
> > > PostGIS.  They are formatted as .dbf files.
> > > 
> > > Is there a dbf2pgsql type utility to do this?  Or will I have to 
> > > resort to Perl and roll my own?
> > 
> > What about patching shp2pgsql instead ?
> > 
> 
> I'd love to.  However that won't work for my this Tuesday deliverable.
> At any rate, what (at a high level) would be involved in patching
> shp2pgsql.c to do this?  I could see this being extended via a "-t" flag
> which means "just insert the .dbf table".
> 
> In the short-term, if anyone has any ideas, that would be much
> appreciated.

I'd use no flags, allowing use of what's available (shp only / dbf only).
You should handle the failures in OpenShape and somehow notify absence
of either shape or dbf file still counting number of rows.

--strk;

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