Re: Import DB from DOS- dbase4

From: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>
To: "Fernando M(dot) Maresca" <fmaresca(at)monssa(dot)com(dot)ar>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Import DB from DOS- dbase4
Date: 2001-12-21 09:01:32
Message-ID: 3C22FA6C.6F289FDA@giaspn01.vsnl.net.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2001-12-21 16:37:00 Re: Import DB from DOS- dbase4
Previous Message denis 2001-12-21 06:05:33 concating numeric with text