Re: Import DB from DOS- dbase4

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Fernando M(dot) Maresca" <fmaresca(at)monssa(dot)com(dot)ar>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Import DB from DOS- dbase4
Date: 2001-12-15 22:14:23
Message-ID: web-529643@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Terrence Brannon 2001-12-16 11:56:20 Numbering Rows (SEQUENCE, OID) questions
Previous Message Stephen Ingram 2001-12-15 22:04:02 Defining aliases for types. Can it be done?