Paradox, dbf and PostgreSQL ?
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)
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 '>'