> ------------------------------
>
> Date: Thu, 19 Aug 1999 10:30:13 -0400
> From: Clive Anderson <[EMAIL PROTECTED]>
> Subject: Importing Paradox database
>
> I am new to postgresql and I am trying to import a paradox database. There
> are some boolean fields in the database that are empty and postgresql does
> not like this. Is there a way to import such a database without supplying a
> (boolean) value for 5*600 fields in the existing database?
>
> TIA,
>
> Clive...
>
> ------------------------------
Export the db file to a delimited text file. suggest you do not use the
Paradox defaults, but set the delimiter to '|' and suppress the
quotation marks for text.
Use:
COPY foo FROM bar.txt USING DELIMITERS '|';
My 486 copied 10,000 records in a few seconds. Boolean fields were not
a problem, most were empty.
To get a specimen of the required txt file use:
COPY foo TO bar.txt USING DELIMITERS '|';
regards
Max Wood
ps - Regret the late delivery, but communications in Africa are not
always first world.
************
