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 по дате отправления: