Re: Import DB from DOS- dbase4 - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Import DB from DOS- dbase4
Date
Msg-id web-529643@davinci.ethosmedia.com
Whole thread Raw
In response to Import DB from DOS- dbase4  ("Fernando M. Maresca" <fmaresca@monssa.com.ar>)
List pgsql-novice
Fernando,

> i working around an application with Postgres as DB server, but the
> data for now comes from a DOS app. and the file format of the
> tables is dbase 4; so, can i import these tables directly into
> postgres tables automatically?
> Are there some kind of utility?

No, unfortunately.  You have two possible methods:

1. Dump the Dbase4 (using the original application) data into a
delimited text file, and then use COPY to load it into Postgres.

2. Use ODBC (or UnixODBC) and an external language (like Java, Perl, or
Python) or database tool (like MS Access, Kylix, or Rekall) to pull data
out of DBase4 and pump it into Postgres.

Good luck!

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: "Fernando M. Maresca"
Date:
Subject: Import DB from DOS- dbase4
Next
From: "Josh Berkus"
Date:
Subject: Re: Storing number '001' ?