Res: Re: [postgis-users] dbf2pgsql type utility

Ezequias Rodrigues da Rocha ezequias at recife.pe.gov.br
Mon May 30 13:15:06 PDT 2005


Yes there is a utility to do that.

It is on the contrib directory contrib of source Postgresql. The instalation
is on the folder you found it. Look for it.

I didn't try to compile this utility but if you have sucess please tell me.

Best regards
Ezequias Rodrigues da Rocha
 
-------Mensagem original-------
 
De: strk at refractions.net
Data: 05/26/05 17:53:44
Para: PostGIS Users Discussion
Assunto: Re: [postgis-users] dbf2pgsql type utility
 
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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050530/d406bbe4/attachment.html>


More information about the postgis-users mailing list