Thread: Paradox, dbf and PostgreSQL ?

Paradox, dbf and PostgreSQL ?

From
Thomas Nagy
Date:
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,
sojust 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
somethinglike that. I'm tempted to use them with PostgreSQL, and I guess there is something to do on these files to
readthem . 
I have tried to convert them with a program called dbf2sql but nothing happened. Has anybody ever succeeded in
convertingsuch 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)

Re: Paradox, dbf and PostgreSQL ?

From
"Stefan Waidele jun."
Date:
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 '>'