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
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? |