Re: Converting from dbase

On Saturday 05 April 2003 17:18, Robert Fitzpatrick wrote:
> >     I suppose You are familiar with some "DBase" tool like
> > Fox, Clipper etc..
>
> No, but I'll look into it if my current approach doesn't resolve the
> issue.
>
> >     (otherwise where did You get those DBF files?).
>
> These are .dbf files from a program a customer is using called ABRA
> (www.abra.com), it is an HR/Payroll software. We are developing their
> Intranet with PHP/PostgreSQL and want to see if we can build a
> PostgreSQL function or PHP class to import or convert regularly and
> maybe even create triggers to check updated PG tables for information
> that came from the dbf files. Flexibility would be great.
>
> >     If the language You are using apparent to be Fox, I can
> > try to find this
> >     code and send to You.
>
> Appreciated, the current approach has not panned out, yet.
>
> > However, there is "dbase" source from contrib dir (7.2
> > version of postgres).
> > You will probably need to change the Makefile.
>
> This is what I'm trying to use and would like to use, dbf2pg. Do you
> know where I can find docs on this or what to change in Makefile?

Here is a stand-alone Mekefile. All You have to do is show
where are postgreSQL includes(libpg-fe.h) and  libpq.so.

Change the first two lines of Makefile:

    libpq_include    = /usr/local/pgsql/include
    libpq_lib     = /usr/local/pgsql/lib

Other settings should be good enough(Depends on which platform You are using).