Re: Import DB from DOS- dbase4

Поиск
Список
Период
Сортировка
От Vijay Deval
Тема Re: Import DB from DOS- dbase4
Дата
Msg-id 3C22FA6C.6F289FDA@giaspn01.vsnl.net.in
обсуждение исходный текст
Ответ на Import DB from DOS- dbase4  ("Fernando M. Maresca" <fmaresca@monssa.com.ar>)
Ответы Re: Import DB from DOS- dbase4  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: denis@coralindia.com
Дата:
Сообщение: concating numeric with text
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Import DB from DOS- dbase4