Re: Import DB from DOS- dbase4

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Import DB from DOS- dbase4
Дата
Msg-id web-529643@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Import DB from DOS- dbase4  ("Fernando M. Maresca" <fmaresca@monssa.com.ar>)
Список 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 по дате отправления:

Предыдущее
От: "Fernando M. Maresca"
Дата:
Сообщение: Import DB from DOS- dbase4
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Storing number '001' ?