Paradox, dbf and PostgreSQL ?

Started by Thomas Nagyabout 25 years ago2 messagesgeneral
Jump to latest
#1Thomas Nagy
Thomas.NAGY@eleve.emn.fr

Hi,

I'm from Nantes, France and I've started learning PostgreSQL a few weeks ago. I've read the manual, but I'm still new, so just tell me if I write nonsense.

My Brother is still on winchose, and he has sent to me some *.dbf and paradox data files that he made with Delphi or something like that. I'm tempted to use them with PostgreSQL, and I guess there is something to do on these files to read them .
I have tried to convert them with a program called dbf2sql but nothing happened. Has anybody ever succeeded in converting such files ? If so, please tell me how to proceed.

Thanks in advance,
Thomas NAGY

----
Linux-Mandrake 7.2
PostgreSQL 7.0.2-6-mdk (works fine)

#2Stefan Waidele jun.
St.Waidele.jun@Krone-Neuenburg.de
In reply to: Thomas Nagy (#1)
Re: Paradox, dbf and PostgreSQL ?

At 02:17 08.03.2001 +0100, Thomas Nagy wrote:

Hi,

I'm from Nantes, France and I've started learning PostgreSQL a few weeks
ago. I've read the manual, but I'm still new, so just tell me if I write
nonsense.

My Brother is still on winchose, and he has sent to me some *.dbf and
paradox data files that he made with Delphi or something like that. I'm
tempted to use them with PostgreSQL, and I guess there is something to do
on these files to read them .
I have tried to convert them with a program called dbf2sql but nothing
happened. Has anybody ever succeeded in converting such files ? If so,
please tell me how to proceed.

What do You mean with 'nothing' happened?
I do not have the docs for dbf2sql, but it sounds like it takes a DBF-File
an prints out the corresponding sql-statements.
It is on You to grab them, write them to a file and run that file through psql.

Should be something like

dbf2sql --your --options --here YourBrothers.dbf >output.sql
psql yourdbname

yourdbname=# \i output.sql

HTH,

Stefan

Disclaimer: The dbf2sql-syntax is pure quesswork! Check the manpage. The
important thing is to write the output to a file, either with an option or
the shell--redirect '>'