Skip site navigation (1) Skip section navigation (2)

Re: dbf2pg, visual foxpro and other nonsense

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: "Mike McCormac" <MikeM(at)jcmh(dot)org>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: dbf2pg, visual foxpro and other nonsense
Date: 2002-07-10 15:19:18
Message-ID: 67102643-9418-11D6-8D98-000502E740BA@wellsgaming.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Tuesday, July 9, 2002, at 10:27 AM, Mike McCormac wrote:

> i've been importing older foxpro tables (x-base files) into postgresql
> with much success using dbf2pg... however, visual foxpro files don't
> seem to work — i just get an error.
>
> does anyone know of any successful means of importing this data
> directly?  our backend application is built in java... are there any
> good solutions with JDBC??
>

You can copy the Foxpro tables to text and then copy them into Pg.

The problem is, Foxpro likes to make its data "dirty" by surrounding text
with quotes, inserting newlines for no reason and things like that, so
you may need to write a script or something that strips all that crap 
out.

Have fun.

--Jeremy


In response to

pgsql-interfaces by date

Next:From: Josh BerkusDate: 2002-07-10 15:44:59
Subject: Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
Previous:From: Hannu KrosingDate: 2002-07-10 14:16:46
Subject: Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group