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: (view raw, whole thread or download thread mbox)
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 

Have fun.


In response to

pgsql-interfaces by date

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

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