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

From Vijay Deval
Subject Re: Import DB from DOS- dbase4
Date
Msg-id 3C22FA6C.6F289FDA@giaspn01.vsnl.net.in
Whole thread Raw
In response to Import DB from DOS- dbase4  ("Fernando M. Maresca" <fmaresca@monssa.com.ar>)
Responses Re: Import DB from DOS- dbase4
List pgsql-novice
Hi

I have imported dBASEIV  tables into Postgresql. I exported the tables
from dBASEIV as delimited text files and then copied in Postgresql. In
some table I needed to drop a field that was to become sequence in
Postgresql. Using gawk script I removed the column, converted the
records into sql insert query and let Postgresql assign sequential
numbers. Used gawk script once again. Now all new records get numbered
automatically. If you are interested, I could send to you gawk and "C"
scripts that I used .

Vijay
"Fernando M. Maresca" wrote:
>
> Hi!
> 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?
> thanks

pgsql-novice by date:

Previous
From: denis@coralindia.com
Date:
Subject: concating numeric with text
Next
From: "Josh Berkus"
Date:
Subject: Re: Import DB from DOS- dbase4